Sunday, 30 December 2012

monitoring audit


select user_name, audit_option, success, failure
        from sys.dba_stmt_audit_opts;

select sessionid, to_char(ntimestamp#,'DD-MON-YY:HH24:MI:SS') login,
userid, to_char(logoff$time,'DD-MON-YY:HH24:MI:SS') logoff
from sys.aud$ where userid='<schema_name>';

select username, priv_used, ses_actions from dba_audit_object;

select action, action_name, username from dba_audit_trail ;

select * from stmt_audit_option_map;

No comments:

Post a Comment