Hi All,
My client has a table with user names and the authorized territory name the user has access to e.g EMEA, APAC etc. The users can also move to a different territory over time and the same will be updated in the user table table. I have multiple data tables and access to the rows will be decided based on which territory the user has access to from the user table. e.g Users with APAC territory in the user table should be able to access only APAC data from the data table.
I want to implement RLS in Unity Catalog, but I am not able to figure out how I can create user groups and potentially update the user assignments to the group based on the User table
Ps I really do not want to use a view to access the territory name from this user table and add additional lookup.