Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

User permission at Table level



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

Super User
Super User



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

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





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 :


Please mark as Answer if it is helpful and provide Kudos

Subscribe :
Blog :



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

Super User
Super User



You will need to do this through solutions and managed properties.  Please review the following:


Hope this helps. Please accept if answers your question or Like if helps in any way.
Helper III
Helper III

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

Super User
Super User



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: 


Hope this works well for your needs.

Hope this helps. Please accept if answers your question or Like if helps in any way.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,040)