Database Administration (MOSC)

MOSC Banner

AUDITING in Oracle 11g database

edited Mar 29, 2016 12:17PM in Database Administration (MOSC) 2 comments

Hi Team,

I executed the below query and got that auditing is not enabled for SYS user:

SQL> select distinct username from dba_audit_trail;

USERNAME

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

PUBUSER

STUDMX03

ASMUSER

PBUSER

AMDUSER

BACKUPADMN

PRIVUSER

SHEHAM07

IBRAAH01

MINER

OPS$DBMOMPRIMNP02

ABDUSB00

SCOTT

ORACLE_OCM

A

BOUWGD00

DBSNMP

SYSMAN

SHIRAZTEST

GARYTEST

ADMUSER

COLOWG00

Is there any other way to check if auditing facility is enable for SYS user or not.

######################

When I check any audit files I see the data present as below:

Audit file /primahome/u01/app/oracle/admin/dbmomprmnp02/adump/dbmomprmnp02_ora_11184_20160312233345070799143795.aud

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

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