The following examples show how to use the SQL statement auditing facility. The first example causes Oracle to audit every CREATE TABLE SQL statement issued by user scott:
AUDIT CREATE TABLE BY scott;
The next example causes Oracle to audit every CREATE USER, ALTER USER, or DROP USER SQL statement issued by anyone in the database:
AUDIT USER;