Forum Discussion

franciscocohen's avatar
franciscocohen
Frequent Visitor
4 years ago
Solved

RLS members export

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 th...
  • lbendlin's avatar
    4 years ago

    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