Individually Auditing Schema Objects
Schema object auditing can audit all SELECT
and DML statements permitted by schema object privileges, such as SELECT
or DELETE
statements on a particular table. The GRANT
and REVOKE
statements that control those privileges are also audited.