• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Row Level Security

Hi,

I am wondering if it is possible to dynamically Filter the data in Row Level Security to match the name of the role. Example below: The Role has a name of Perioperative Services. In the data, I want the filter to be on Div Desc = Perioperative Services. However, we have movement and name changes often. I would like to just edit the role name and the filter to follow that if possible (when the role name is changed).

1755281038118.png
 
We use Entra Group IDs that are independent of org structure and names. In Entra we can rename those groups whenever needed to whatever. RLS is solely on the Entra ID.
 
Back
Top