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