Hi,

I tried to enable auditing on one of the tables using the steps below:
  1. run command
    Code:
    alter system audit_trail=true scope=spfile
    and restart database

  1. run command
    Code:
    audit delete, insert, update on test_user.test_table

  1. run command 'select * from dba_obj_audit_opts;'
    Results:
    Code:
    OWNER                          OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------------------ -----------------
ALT       AUD       COM       DEL       GRA       IND       INS       LOC
--------- --------- --------- --------- --------- --------- --------- ---------
REN       SEL       UPD       REF EXE       CRE       REA       WRI
--------- --------- --------- --- --------- --------- --------- ---------
FBK
---------
TEST_USER                        TEST_TABLE                         TABLE
-/-       -/-       -/-       A/A       -/-       -/-       A/A       -/-
-/-       -/-       A/A       -/- -/-       -/-       -/-       -/-
-/-


After which i run the following sql:
Code:
SQL> insert into test_table values (1234, 'test test');
and exit sqlplus.

When i login as SYSDBA and check AUD$ table, the column 'SQLTEXT' contains null and does not have the sql which was run. However, the AUD$ table register user TEST_USER ran an INSERT statement on TEST_TABLE.

Is there a parameter which must be turned on to solve this?

Thanks in advance!