DQL Query ACL and Groups

fchar

Dears All,

could you kindly provide me a DQL query to find all users not belonging to a specified ACL and part of given groups ?

Thanks in advance!

Kind Regards

JorgKrause

Hi,

all users that are not specified in ACL directly, or as group members?

Try this

select distinct user_name from dm_user whereuser_name not in (select r_accessor_name from dm_acl where object_name = '<your acl>')and user_name not in     (select i_all_users_names from dm_group where group_name in          (select r_accessor_name from dm_acl where object_name = '<your acl>'))and r_is_group = Falseenable (ROW_BASED)

Regards

Jørg