Forum Discussion
Row Level Security with Multiple levels (Complicated)
Hi, I am looking to implement RLS for multiple levels. I have 2 tables as below. 1) Groups 2) Tasks Groups table will have , Group name and Member email. And tasks will have below ...
Is this the filtering expression you're after?
Tasks[SubmittedBy] = USERPRINCIPALNAME () || Tasks[IsRestricted] = "No" || Tasks[RestrictedAccess] IN CALCULATETABLE ( VALUES ( Groups[GroupName] ), Groups[Members] = USERPRINCIPALNAME () )Hi Anonymous ,
you can distribute the rules into own role and then apply them additively to the users.
AlexisOlson
Super User
Super UserIs this the filtering expression you're after?
Tasks[SubmittedBy] = USERPRINCIPALNAME ()
|| Tasks[IsRestricted] = "No"
|| Tasks[RestrictedAccess]
IN CALCULATETABLE (
VALUES ( Groups[GroupName] ),
Groups[Members] = USERPRINCIPALNAME ()
)AlexisOlson really brilliant and you got it with just one rule, i was doing 3 rules all these times.
but this is really great. thanks for your time.