Framing this question;
I have a Canvas App - for this question I'll create a Blank Canvas app
I have a SQL Server Connection
For this question - I will do a simple ClearCollect(colName, SqlServer View)
The connection I am using has db_owner access on the Database -
If I for whatever reach -- in this specific example - I needed to Drop the View and recreate it, to change a join condition -
When running the app - - it seems the app did not have access to the view and I needed to update the Permissions specifically on the
view to allow access.
With the connections - is there anything unique in view and table access - where if I remove the object on the database - I will need to
re-create the specific object as well?
I noticed this also when using a Trigger - in that I needed to specifically grant the permissions - even though the user has db_owner access.
unsure if this is a Permission propagation on new objects, or if it's a connection/connector behavior when new objects are created?
