Forum Discussion

cscheib's avatar
cscheib
New Member
8 years ago

Automatically assign a role to all members (RLS)

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

2 Replies

  • caseycook's avatar
    caseycook
    Helper I
    8 years ago

    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's avatar
      cscheib
      New Member
      8 years ago

      I have already voted for that :smileyhappy:

      Hopefully they will implement it soon...