Power Platform Community Forum Thread Details

Hello Power Users,

Each time I build and app on a custom table I create on data verse, I update "Basic User" role permissions on the custom table to let them create a record. For example I create App A on data verse and the table name is AppTableA. I go to settings and Update "Basic User" role permissions on the AppTableA to create a record. What If I create another app, App B on data verse table AppTableB. Do I have to manually go to settings and update "Basic User" permissions to create record on the App B?

Is there a way that "Basic User" is by default set so that user is capable of creating records on the app I build using dataverse as database?

Thanks in advance!

Categories:

Microsoft Dataverse with Power Apps

Hello, Thanks for reaching out.

A few things to clarify here. Users need a security role that is assigned to an app for "access", the users need a security role that give them "authorization" to perform actions on records, like create or read. With that in mind you can use the same security role to provide access to both apps. Typically, I copy Basic User security role and create one for each app so I can separate access. Then I copy Basic User again and create a Core User role, which I then give authentication privileges to for the custom tables and whatever else is needed.

This would give you a Security role for App A access, and a Security role for App B access and one security role for Core User that all users are assigned to. Now the only time you would need to update Core User was if you created a new table.

Now the topic for automated assignment of security roles is something else. I have placed a link to a blog that walks through this. Essentially you can create a team that syncs with an Azure Active Directory user group and this team can be assigned a security role, so any users in that AD group will inherit the security role assigned to that team.

Using Azure Active Directory groups to manage a user’s app and data access - Microsoft Dynamics 365 Blog

Please mark as a solution or give a kudos if this helped at all.
Good luck and have a great day!