Database Security Products (MOSC)
MOSC Banner

audit not exists return code

edited Apr 11, 2018 9:06PM in Database Security Products (MOSC) 1 commentAnswered ✓

Hello,

I'm working on a 11.2.0.4.0 Enterprise edition database and I wanted to test the "audit not exists" statement described in Oracle® Database Security Guide 11g Release 2 (11.2) E36292-09 but when I run a SQL statement that generates an ORA-00942 error message, I have different return codes:

Here are my audit parameters:

audit_trail = XML, EXTENDED

audit_sys_operations = TRUE

audit_syslog_level =

When I run the script described in DOC ID: 287436.1 SCRIPT: Generate AUDIT and NOAUDIT Statements for Current Audit Settings, I get this result:

AUDIT STATEMENT

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

AUDIT CREATE SESSION  BY ACCESS ;

AUDIT NOT EXISTS  BY ACCESS ;

SQL> select * from sys.audit$;

Tagged:

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