Database Administration (MOSC)

MOSC Banner

dba_audit_trail does not monitor sysdba

edited Mar 24, 2015 10:00AM in Database Administration (MOSC) 3 commentsAnswered

I want to be able to monitor sysdba activity in dba_audit_trail view.

I have set audit_sys_operations to TRUE

SQL> show parameter audit_sys_operations

NAME                                 TYPE                           VALUE
------------------------------------ ------------------------------ ------------------------------
audit_sys_operations          boolean                        TRUE

I connect as SYSTEM and run

SQL> create user tt identified by tt;

User created.

SQL> drop user tt;

User dropped.

This commands are logged in the view.

The I connect as SYS and run the same commands. These commands are not logged in the view. Why. What I'm I missing?

Also I have set

SQL> show parameter audit_trail

NAME                                 TYPE                           VALUE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center