Database Administration (MOSC)

MOSC Banner

Oracle audit

edited Nov 10, 2015 10:13AM in Database Administration (MOSC) 7 commentsAnswered

I am trying to audit all the database activities to the user who has DBA role privilege. I issued the command below:

audit all by username by access;

However, it was not generated the audit trails in event view log when the user is logging into the database using SQL developer from the other machine.

Is there anything missing? Below is the audit parameter value in my system.

Thank you so much for the help!

********************************************************************************************************************

SQL>  show parameter audit AUDIT_SYS_OPERATIONS

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      F:\ORACLE\PRODUCT\10.2.0\ADMIN
                                                 \DATABASENAMEHERE\ADUMP
audit_sys_operations                 boolean     TRUE

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