Oracle Directory Permissions Report
This script displays permission details for a specified Oracle directory object. It queries the DBA_TAB_PRIVS view to show granted privileges, grantees, grantors, and owners, helping DBAs review access control and security settings for directory objects.
oraclesqlsecurity-auditingv1.0.0
0 stars0 downloads13 views0 comments
By OracleDba • Created
Code
(19 lines)12345678910111213141516171819
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/directory_permissions.sql
-- Author : Tim Hall
-- Description : Displays permission information about all directories.
-- Requirements : Access to the DBA views.
-- Call Syntax : @directory_permissions (directory_name)
-- Last Modified: 09/02/2016
-- -----------------------------------------------------------------------------------
set linesize 200
column grantee format a20
column owner format a10
column grantor format a20
column privilege format a20
column
select *
from dba_tab_privs
where table_name = upper('&1');