I’m trying to create a row level security on user level. I had created a primary SPICE dataset with username & market columns, And created another SPICE dataset with username & market columns. However when i try to add second dataset as row level security it doesn’t work.
My question is -
–can we use SPICE dataset as Row level security dataset ??
–Can the owner of the dataset will have access to the published dashboard post creating the row level security ??
–Also please let me know the issue on the above one ??
It appears the issue is related to how you have named the columns. The UserName and GroupName are like keywords. So you need to name them accordingly.
Please change your column name in the RLS dataset to have UserName. Per say your primary dataset does not require user name, it should have the column(s) on which the RLS works which I guess is the market column. In the RLS dataset you specify which user has access to which market (comma separated).
