DBA Hub

📋Steps in this guide1/1

Privileges Audited in database

col user_name for a12 heading "User name" col privilege for a30 heading "Privilege" set pages 1000 prompt prompt System Privileges audited across system select user_name,privilege,success,failure from dba_priv_audit_opts order by user_name, proxy_name, privilege /

oracle configurationintermediate
by OracleDba
13 views
1

Privileges Audited in database

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
col user_name for a12 heading "User name"
col privilege for a30 heading "Privilege"
set pages 1000
prompt
prompt System Privileges audited across system
select user_name,privilege,success,failure from dba_priv_audit_opts
order by user_name, proxy_name, privilege
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!