Audit enabled, function call in select writes a lot of audit trail
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
0