The DQL to query the list of groups that a user belongs to:
select group_name from dm_group where any users_names = ‘<user id>’;
To query all groups to which a user belongs whether directly or indirectly, use:
select group_name from dm_group where any i_all_users_names = ‘<user id>’;
To query for groups the logged in user belongs to, use:
select group_name from dm_group where any i_all_users_names = USER;
Leave a comment