ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E2534B6CA8D641F0852D3294E016CCEBY select dd.directory_name, dd.directory_path, dd.owner, (select listagg(dtp.grantee||' ('||lower(dtp.privilege)||')',', ') within group (order by dtp.grantee, dtp.privilege) from dba_tab_privs dtp where dd.owner=dtp.owner and dd.directory_name=dtp.table_name) grants from dba_directories dd where 1=1 order by dd.directory_name US DBA Directories Database directory objects with their operating system path and the users granted read, write or execute access to them. Enginatics 1=1 1 10 1=1 dd.directory_path like :directory_path Char US Directory Path like