I come to you today because I have a problem with the Oracle audit function.
I set the server as follow : ALTER SYSTEM SET AUDIT_TRAIL = db,extended SCOPE = SPFILE; SHUTDOWN IMMEDIATE STARTUP SHOW PARAMETER audit : audit_trail = db, extended audit_sys_operations = true
(classic audit, not FGA)
Then, I set an audit on my test table : AUDIT INSERT, DELETE, UPDATE ON TEST.MYTABLE BY ACCESS WHENEVER SUCCESSFUL
When launching a statement like this one : update test.mytable set name_user = 'johan' where id_user =102;
results have nothing on the SQ_BIND column from DBA_AUDIT_OBJET when the SQL_TEXT column is correctly filed.
My Oracle version is 220.127.116.11.0 64bits.
Do you have any idea for this issue ?
Thanks by advance.
(Sorry for my english, this is not my native language)