Row level security with multiple users

[Anonymous]

Hi team,
New query that we are facing is we have multiple users who will be accessing 3 dashboards.
Role that we have created is based on which dashboard to show to which user.
For example user A will access only First dashboard, so for FIrst dashboard we have created role named FIRST and have assigned that role to user A in servers manage permissions.

What if I give another role to user A to access Second dashboard and assign SECOND role to same user.
How will it work?
Since in azure directory there will be 2 records of same user one with FIRST role and other with SECOND??

Regards,
Honey Bhatia

[Greg_Deckler · Accepted solution]

I do not anticipate a problem with that. A user should be able to be assigned to multiple roles. It's kind of like groups in active directory. You can put a single user into multiple groups and there is no issue.

[swragg]

Can you show how that looks in practice?

For example, if I have 100 000 rows of data that I upload regularly to be seen by user 1, how doe I make that available to user 2?

DUplicate the 100 000 rows?