Skip to main content
Community site session details

Community site session details

Session Id : OB1FC7PoPZ9G3U2ZPLq+kd
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:
  • Mamacona Profile Picture
    58 on 20 May 2022 at 16:29:31
    Re: Security Roles for all the organization

    Thank you very much, i will apply this, the guidance helps a lot. I appreciate it.

  • 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 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics

Loading complete