Database Administration (MOSC)

MOSC Banner

Audit enabled and no SQL Text is recorded

edited Jun 19, 2018 4:12PM in Database Administration (MOSC) 11 commentsAnswered ✓

Hi I enabled Audit and looks start auditing .  I did following steps after enabled in DB level

AUDIT select,alter,INSERT, DELETE, UPDATE ON  <Schema>.<table> BY ACCESS WHENEVER SUCCESSFUL;

select  os_username, username,userhost,terminal,obj_name,action_name,timestamp,SQL_TEXT   from  dba_audit_trail.

can find records are start auditing. But not able to find executed SQL. This SQL_TEXT has null.  How to audit command executed. I referred 1299033.1 doc

Any one can help me would be greatly appreciated.

Thanks

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