This permissions dataset has conflicting key column formats. You can use either names (UserName, GroupName) or ARNs (UserArn, GroupArn) in key columns, but not both in the same permissions dataset

Question & Answer
, , ,
1

I’ve got a query that has both UserArn (for RLS) and UserName (for dynamic parameter default values) columns. There are some exceptions due to certain folks being tied to wrong buildings so I have to manually manipulate so that they can be NULL to receive all the data.

I’m trying to avoid needing to have two separate datasets where I’d need to copy/paste the exceptions in two separate locations but came across this error: This permissions dataset has conflicting key column formats. You can use either names (UserName, GroupName) or ARNs (UserArn, GroupArn) in key columns, but not both in the same permissions dataset. Learn more

Any work around? Anyway I can tell RLS that I want it to ignore UserName column?

2

Hello @Clayton_Barton !

I do not believe that there is a way to get the RLS to ignore the username column. After looking into this more I think that creating the two datasets will be your best way forward.

I will mark this as a feature request.

3