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 there a way for doing this?

Thank you,

FC.

Need Help
  • lbendlin's avatar
    lbendlin
    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

     

     

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    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