DBA Directories

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Database directory objects with their operating system path and the users granted read, write or execute access to them.
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
Parameter NameSQL textValidation
Directory Path like
dd.directory_path like :directory_path
Char
Download
Related Blitz Reports
DBA Object Access Privileges DBA ORDS Configuration Validation DBA Table Modifications FND Audit Setup DBA Table Columns Blitz Report VPD Policy Setup DBA SGA+PGA Memory Configuration DBA Undo Statistics XLA Distribution Links Summary
Blitz Report™