Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

undefined

I am trying to create a Static RLS where few should have access where column Phone has "Apple" and other should have access of all data no filter of column Phone

Need Help

1 Reply

  • erickeu's avatar
    erickeu
    Advocate I
    2 years ago

    Hi,

    create two RLS one with filter and another without any restricttion;

    RLS_AppleOnly : TableName[Phone] = "Apple"
    RLS_ALL : nothing,
    and then you asign one role to some group of customers and the add the rest to the RLS_ALL 

    if this helps please mark it as a solution 🙂