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;