Dataverse custom table permission

[PaulMatha]

Hi,

I have Canvas app/ Dataverse solution that I would like to share with all team members, who have the required power app licence.

I have a custom table in the solution, but other user cannot see the table data in canvas app: gallery control.

I am not sure, what I am missing:

My tried out solution that did not work:

1:  Editing security role and add full permission to custom entity/table, 

mentioned in: https://docs.microsoft.com/en-us/power-apps/maker/model-driven-apps/share-model-driven-app#create-or...

2: Adding a new security role and add it in solution.

3: Adding a co author role to the user.

The only thing that worked was providing my user power platform admin access.

mentioned in : https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataverse-Environment-and-Table-Permission/m...

I cannot provide  admin access to all the user.

Is there any other solution or work around?

Please let me know if I have missed anything.

Any help is appreciated.

[ChrisPiasecki]

Hi @PaulMatha,

When you say you granted your user "co author role", is that that the name of your new custom security role? Or do you mean you set the person as co-owner of the app?

You need to assign your user the custom security role with permissions to the custom tables in order for them to see the data. Setting the user as a co-owner of your app does not give them access to the data, only the ability to modify your app which you probably don't want.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[PaulMatha]

Hi @ChrisPiasecki ,

Thank you for the reply.

Yes, I have given the user: co-owner access. ( I am trying all possible solution)

I have also created custom security role and assigned it to user.

But I cannot see the Dataverse table in power app.

I there something that I have missed?

[ChrisPiasecki]

Hi @PaulMatha,

How did you create your custom security role? Did you copy the basic user role and then add the additional permissions for the custom table? Or did you create it from scratch? It's recommended to copy the basic user role and modify that copy since the basic user role has a bunch of core permissions needed to properly use an app (e.g read privileges to a bunch of tables under Customization tab).

More details are mentioned here.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[PaulMatha]

Hi @ChrisPiasecki ,

Created as a copy from basic user.

Followed the creation steps mentioned in the link you have provided.

[ChrisPiasecki · Accepted solution]

Hi @PaulMatha,

Can you try to check the users access to a particular row in one of your tables to see if they truly have access?

You can use the Check Access command in a form to do so. More information here.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[PaulMatha]

Hi @ChrisPiasecki ,

I am working on canvas app, I am not sure if I can use Check Access command in a form.

However, user can see all the data, when login into table:

[PaulMatha]

Hi @ChrisPiasecki ,

Thank you for all you help.

I was able to solve my problem.

The issue was with column security as table security and column security is different.

Your comment to check row level access was helpful.