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 ...
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...