DCTM – Get user permissions in ACL

below query gives the result

 

select * from dm_user where
(
user_name in
(
select distinct(i_all_users_names) from dm_group where group_name in
(
select r_accessor_name from dm_acl where object_name = ‘<ACL_NAME>’ and r_accessor_permit >= 4
)
)
OR
user_name in
(
select r_accessor_name from dm_acl where object_name = ‘<ACL_NAME>’ and r_accessor_permit >= 4
)
)
and user_name = ‘<USER_NAME>’
enable(row_based);

 

source: https://community.emc.com/thread/196461

Also can use

execute check_security with username=’username’, level=x, object_list=’listofobjectids’ with groupname=’groupnamehere’ for groups