User permission at Table level

(0) Share

Report

Posted on by PRAVEENZNMD

Hello,

Is it possible to restrict permission of user at table level? Here is the scenario:

1. User needs access to create tables and columns in dataverse

2. User should not be able to customize other custom table (add/edit columns, read access is fine)

Please advise

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @PRAVEENZNMD,

Hope you are doing good.

We can customize this type of behavior using Security Roles in Dataverse Environment.
Please follow below steps to proceed further.

1. Navigate to https://make.powerapps.com
2. Click Gear Icon at the Top --> Select Advance Settings
3. Once Advance settings Page Loaded --> Select Settings --> Select Security
4. Click Security Role
5. Open any Existing or Click New to Create a new Security Role
6. If it is a Custom Entity Navigate to Custom Entity Tab else you can find the Table Name in Core Records

These are the below Key Behavior Available in Dataverse

User:

If We Provide Create/Read/Write/Delete as User Level then Logged in User Can Create Record and he can Only Read his Record/ Delete and Write the Record

Business Unit --> Users in his respective BU can perform the same operation who ever creates
Same way for Parent Child

Organization --> Any One can Create/Read/Write/Delete record because he is having Global Level Access

For More Information : https://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
PRAVEENZNMD 96 on at

Like (0)

Report

Hello @rampprakash ,

Thank you for your update. Above solution will only hide data inside a table to user based on the permission we granted.

We have to provide access to user to create columns at particular table level. What we did was granted access to "Field" at customization tab which will in turn grant access to all tables. But we are looking for this permission at a single table

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @PRAVEENZNMD ,

You will need to do this through solutions and managed properties. Please review the following: https://docs.microsoft.com/en-us/power-platform/alm/managed-properties-alm

Was this reply helpful? Yes No
PRAVEENZNMD 96 on at

Like (0)

Report

Hello @dpoggemann , will try this option and will keep you posted. Thank you so much for your update!

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @PRAVEENZNMD ,

Be conscience that the solution with these tables / resources that you want to make read-only in the environment would need to be managed solutions so they would need to be developed in a different environment and promoted to the environment you are discussing above with the appropriate managed property configuration. If you were all developing in only one environment then you would not be able to restrict that I know of... Please review the solution concepts here: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/solutions-overview

Hope this works well for your needs.

Was this reply helpful? Yes No