enabling Audit 8007 Instance

SELECT *

FROM dba_priv_audit_opts;

　

SELECT *

FROM v$parameter

WHERE name like '%audit%';



SELECT privilege,success,failure FROM dba_priv_audit_opts WHERE user_name = 'SYS';

SELECT username,

extended_timestamp,

owner,

obj_name,

action_name

FROM dba_audit_trail

WHERE owner = 'APPS'

ORDER BY timestamp;

SELECT privilege,success,failure FROM dba_priv_audit_opts WHERE user_name = 'APPS';

　

PRIVILEGE SUCCESS FAILURE

---------------------------------------- ---------- ----------

CREATE ANY TABLE BY ACCESS BY ACCESS

DROP ANY TABLE BY ACCESS BY ACCESS

ALTER ANY TABLE BY ACCESS BY ACCESS

USER_NAME PROXY_NAME PRIVILEGE SUCCESS FAILURE

　

APPLSYSPUB DROP ANY TABLE BY ACCESS BY ACCESS

APPLSYS DROP ANY TABLE BY ACCESS BY ACCESS

APPS DROP ANY TABLE BY ACCESS BY ACCESS

SYSTEM DROP ANY TABLE BY ACCESS BY ACCESS

APPLSYSPUB ALTER ANY TABLE BY ACCESS BY ACCESS

APPS ALTER ANY TABLE BY ACCESS BY ACCESS

APPLSYSPUB CREATE ANY TABLE BY ACCESS BY ACCESS

APPLSYS CREATE ANY TABLE BY ACCESS BY ACCESS

APPS CREATE ANY TABLE BY ACCESS BY ACCESS

SYSTEM CREATE ANY TABLE BY ACCESS BY ACCESS

CREATE SESSION BY ACCESS BY ACCESS