Dataverse Table Permission

[ahamadsaiful]

Hi all. I'm the owner of the app and i want to share my app to everyone in the organization. There's a group user (User) can only create & update their own application. Once they submit the application, it goes to their respective manager for approval. However the manager can approve/reject the application and at the same time create, update his/her own application and submit to Head of Department for approval. Understand that i can control the role access via the apps. However if i set permission for the application table as Member with Full access, does it mean all user can access the table when they trying to build new app? Is there any other table permission i can set for application table?

[EricRegnier]

If you don't share the app with other users outside of the Teams then they won't have access, and only users within the Teams channel will have access. If this is the general channel or a common channel, then I would create a new channel for only those restricted users that can access the sensitive data.

[ahamadsaiful]

@EricRegnier noted on the creating new channel. Assuming i've created new channel for the Manager with Full Access permission. Do they have direct access to the Application table? Can the Manager use the Application table for building another powerapp? Because my concern is even though i can control the access via the app, the Manager still can access the table.

[EricRegnier · Accepted solution]

Great question, and unfortunately no, any member of the team channel will be able to create other apps, access/edit the tables, etc. This is a current limitation of DV4T. The only restriction you can have is privileges on the actual records/rows of the tables...

[ahamadsaiful]

@EricRegnier Noted. Thank you very much for your detail explanation. Really appreciate your help