DBA Hub

📋Steps in this guide1/1

Statements audited in oracle

col user_name for a12 heading "User name" col audit_option format a30 heading "Audit Option" set pages 1000 prompt prompt System auditing options across the system and by user select user_name,audit_option,success,failure from sys.dba_stmt_audit_opts order by user_name, proxy_name, audit_option /

oracle configurationintermediate
by OracleDba
12 views
1

Statements audited in oracle

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
col user_name for a12 heading "User name"
col audit_option format a30 heading "Audit Option"
set pages 1000
prompt
prompt System auditing options across the system and by user
select user_name,audit_option,success,failure from sys.dba_stmt_audit_opts
order by user_name, proxy_name, audit_option
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!