Database Administration (MOSC)

MOSC Banner

Audit enabled, function call in select writes a lot of audit trail

edited Aug 1, 2019 6:22AM in Database Administration (MOSC) 11 commentsAnswered

Hi

Oracle 12.1.0.2.0 (compatible=11.2.0.4.0)

I have noticed something strange with some sql's where there is function call inside select (audit enabled).

This is the example, that I have tested it with:

/*In another session*/SQL> show parameter audit_trailNAME           TYPE     VALUE-------------- -------- ----------------audit_trail    string   DB, EXTENDEDgrant select on dba_audit_trail to raulk_haldur;grant create table to raulk_haldur;alter user raulk_haldur quota 10M on users;grant create procedure to raulk_haldur;SQL> AUDIT SELECT TABLE BY RAULK_HALDUR BY SESSION;--ORSQL> AUDIT SELECT TABLE BY RAULK_HALDUR BY ACCESS;--(I still don't understand what is the difference between these two (BY SESSIOND vs BY ACCESS), I have read the documentation like several times 

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