Exporting list of emails from Row Level Security Section

[Anonymous]

Hi Everyone,

I'm struggling trying to extract all emails added from Row Level Security section per each role. We have several emails (+2000).

You may know some trick to extract them as csv or another extension.

Thank you in advance.

[Anonymous · Accepted solution]

HI @Anonymous,

I'd like to suggest you create dynamic RLS roles based on username, it should reduce the workload and complexly on RLS settings. Please check the blog(written by GilbertQ) that mention in the following link to help you clarify the dynamic RLS role setting.

RLS with UserName() 

Notice:

1. RLS with username does not mean you had to set the filter on usernames, it also can be work to use the current username to look up corresponding fields and apply filters if you configure on the user mapping table. (e.g. city, region, gender)

2. RLS roles also can be assigned with a group instead of manually dispatch to each user. (use security group)

3. If you only want to export the user list that accesses the content, you can check the following link:

Access to App Workspaces and list of users who have access 
Regards,

Xiaoxin Sheng

[GilbertQ]

Hi there

Could you give more details around what you mean by extracting emails from Security section?

[Anonymous]

Yes, as we only see microsoft user name in RLS instead of emails, that's why I want to extract the emails from those list. I have 6 roles and in each one we have more that a thousand user added and for example:

My email could be example.other@gmail.com

but in row level security section appear like OTHER, EXAM(CITY)