DB version: 11.2.0.4
AUDIT_TRAIL is set to DB in my database.
If I am not mistaken , below is the command to audit all SELECTs and DMLs by any user on a table (say scott.emp).
SQL> show parameter audit_trail
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string DB
SQL>
SQL> AUDIT SELECT, INSERT, DELETE, UPDATE
ON scott.emp
WHENEVER SUCCESSFUL;
Audit succeeded.
Now, Which dictionary view can I use to see what tables have fine grained auditing enabled ? The above audit command enabled Fine grained auditing on SCOTT.EMP table . Similarly, I want to know what are the other tables where fine grained auditing is enabled. DBA_FGA_AUDIT_TRAIL view didn't provide this info .
SQL> select OBJECT_NAME from dba_fga_audit_trail;
no rows selected