cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joew72
Advocate I
Advocate I

Security Role - Read and Write privileges across multiple users but not entire business unit

I have a security role and a custom table.

 

The table is currently set to USER read and write security privileges on this particular security role.

 

I want to set the table to be read and write by more than 1 USER but not across an entire BUSINESS UNIT. The user(s) who can read and write the record will vary each time so it cannot be reflected simply by changing BUSINESS UNIT or creating different SECURITY ROLEs.

 

Is there a way to set up the read and write security configuration for a table to be based on specific USERS (e.g. those related to the record) or is this not possible?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
joew72
Advocate I
Advocate I

Aaaaand for anyone reading this, I've managed to answer my own question 5 minutes after posting this. Sorry. I'll keep it here in case anyone else comes across the same issue.

 

If I keep the read and write setting to just USER under this security role but select that the USER also has the SHARE privilege. When the user creates (I had not previously mentioned this but assumed it was a given that they had create privilege) the record they can then SHARE the record with the relevant USER and choose which security privileges the other USER will have (within the privileges that the user has within their own security role).

 

Hope that makes sense!

View solution in original post

1 REPLY 1
joew72
Advocate I
Advocate I

Aaaaand for anyone reading this, I've managed to answer my own question 5 minutes after posting this. Sorry. I'll keep it here in case anyone else comes across the same issue.

 

If I keep the read and write setting to just USER under this security role but select that the USER also has the SHARE privilege. When the user creates (I had not previously mentioned this but assumed it was a given that they had create privilege) the record they can then SHARE the record with the relevant USER and choose which security privileges the other USER will have (within the privileges that the user has within their own security role).

 

Hope that makes sense!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (3,508)