2 Replies Latest reply: Apr 29, 2013 2:02 AM by 1005756 RSS

    Audit problem - SQL_BIND column

    1005756
      Hi,

      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 11.2.0.1.0 64bits.

      Do you have any idea for this issue ?

      Thanks by advance.

      (Sorry for my english, this is not my native language)