Database Security Products (MOSC)

MOSC Banner

Oracle Database Auditing: dba_audit_trail table

edited Feb 1, 2013 6:08AM in Database Security Products (MOSC) 9 commentsAnswered ✓
Hi,
from where i found the information about statementid,returncode of dba_audit_trail table.
These columns are populated in numbers.

Thanks
Asif Ghazi

<<UPDATE>>
Hi,

Oracle Database version is 11.2.0.3, and parameter audit_trail is set to DB, EXTENDED.

I execute two create table statements, one is successfully executed with RETURNCODE '0' (which mean successfully executed) but
other same create table query didn't perform because same table is already exists with RETURNCODE is '955'.

My question is, is there any list/table in Oracle database available for getting such information.

ACTION    STATEMENTID    RETURNCODE    ACTION_NAME    PRIV_USED              SQL_TEXT

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