RLS members export

[franciscocohen]

Hi,

I have multiple datasets in my workspace where I have added members to the security RLS.

I need to query or export for each of my datasets wich members I have granted permission to each.

Is there a way for doing this?

Thank you,

FC.

[lbendlin · Accepted solution]

Connect to the XMLA endpoints with your favorite tool and then run these DMV queries

select * from $SYSTEM.TMSCHEMA_ROLES
select * from $SYSTEM.TMSCHEMA_ROLE_MEMBERSHIPS