SYS.AUD$ empty on table auditing
Hi:
I am trying to audit a particular table on 11g (11.2.0.3.0), but I may be missing something. Here is what I've done so far:
Changed init file to
audit_trail = DB
in sqlplus:
SQL> audit INSERT, UPDATE, DELETE ON ap.ap_supplier_sites_all;
-----the audit parameters are as follow
SQL> show parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u02/oracle/OMACRP2/db/tech_st/11.2.0/rdbms/audit
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB
What am I missing?
Thanks a lot and cheers,
AJ