Database Administration (MOSC)

MOSC Banner

DB Audit -Oracle 19c

Oracle 19c SE2 AIX

Hello Gurus, Not sure why the audit records are not getting generated any guidance would be really helpful.

 1* select name,value from v$parameter where name='audit_trail'

SQL> /


NAME              VALUE

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

audit_trail          DB


SQL> grant connect to test identified by test1234;


Grant succeeded.


SQL> grant select any table,create session to test;


Grant succeeded.


SQL> audit all by test;


Audit succeeded.


select audit_option,user_name from dba_stmt_audit_opts where user_name='TEST'

AUDIT_OPTION          USER_NAME

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

SELECT ANY TABLE        TEST

MINING MODEL          TEST

INDEX             TEST

NOT EXISTS           TEST

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