Hi,
I am trying to retrive the acl name to which user belongs in particular folder.
Thanks,
Vishal
Try it
Select object_name from dm_acl where object_name in (select acl_name from dm_folder where ('<Your folder>',descend)) and any r_accessor_name in (select user_name from dm_user where user_name='<Your user_name>')
Hope it helps,
Elchin