Skip to main content
Community site session details
Power Apps - Microsoft Dataverse
Answered

Security Roles for all the organization

Like (0) ShareShare
ReportReport
Posted on 20 May 2022 12:11:54 by 58

Hello

I am new building secutiry roles, I have a canvas app using a dataverse table. I see I can asign the Basic role to the user, but in this case I want to assign this role to all the organization, is there a way to do it directly for all instead of adding one by one?

I need them to only read and create their own rows, and another group among them will have the posibility to read other rows only of their email is inside a row of that table, (these are the approvers and if they are inside the row they can see it).

Thank you in advance.

Categories:
  • Verified answer
    Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 20 May 2022 at 15:27:00
    Re: Security Roles for all the organization

    Hi @Mamacona ,

     

    The best way to do this is to integrate a security role in Azure AD to the environment.  This will allow you to utilize a Team in Dataverse that will contain all these users and you can assign the security role to the team and not need to assign to each user.  Utilizing security roles and team integration helps put the management of the security in hands of administrators in Azure AD vs. requiring going in and setting in Dataverse to simplify management.

    https://docs.microsoft.com/en-us/power-platform/admin/database-security 

     

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics