I am using the following query to find out the user names and their permission level in a particular folder and their subfolders
select g.i_all_users_names,a.r_accessor_permit from dm_sysobject f,dm_acl a,dm_group g,dm_user s where f.acl_name=a.object_name and s.user_name=a.r_accessor_name and s.user_name=g.group_name and folder ('/folderpath',descend) order by i_all_users_names enable(ROW_BASED)
There are many subfolders listed within this path. I want the name of those folders also. When I am giving f.object_name, the DA stops responding. Please suggest what to do to get the folder name, user name and the accessor permit all together.
