I am trying to find all the acl's associated for a user. can someone help me what dql to use to get a list of all ACL's for a specific user has been added to.
How about:
select * from dm_acl where any r_accessor_name = 'dmadmin' or any r_accessor_name in (select group_display_name from dm_group where any i_all_users_names = 'dmadmin')
That works
Thanks a lot
Glad I could help. Want to mark the question as answered? Thanks.
