Automatically assign a role to all members (RLS)

[cscheib]

Hi Everyone,

i have implemented Row-Level-Security based on USERPRINCIPALNAME() and the email adress of the users. It is working fine. Therefore, I have created one role, on which every employee shall be assigned. However, I have over 200 users using the reports. Is there a way to automatically assign every email adress of the users to this single role?

Thanks for your help!

Christoph

[caseycook]

I have this same need.  Seems like it would be good to have a "default" security role.  Anyone accessing the dataset would be a member of that security role if they are not listed in any other role.  Does anyone know how to acomplish this?

I did find an idea to vote for: Default Role for RLS

[cscheib]

I have already voted for that

Hopefully they will implement it soon...