System privilege auditing lets you track the use of system privileges. In the AUDIT command, you can specify any system privilege. An audit record will be generated any time you exercise the specified system privilege. You are also able to audit the exercise of a system privilege by all users or a specific user.
AUDITsystem_privilege
[,system_privilege
...] [BYuser
[,user
...]] [BY SESSION [WHENEVER [NOT] SUCCESSFUL] [BY ACCESS [WHENEVER [NOT] SUCCESSFUL]
In this case, system_privilege can be any system privilege or one of the system privilege shortcuts. Table 7.4 lists all the system privilege shortcuts that have been defined.
System Privilege Shortcut |
System Privileges Represented |
CREATE SESSION | |
ALTER SESSION CREATE CLUSTER CREATE DATABASE LINK CREATE PROCEDURE CREATE ROLLBACK SEGMENT CREATE SEQUENCE CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE VIEW | |
SYSTEM GRANT statement option AUDIT SYSTEM CREATE PUBLIC DATABASE LINK CREATE PUBLIC SYNONYM CREATE ROLE CREATE USER | |
Equivalent to all SQL statement options in Table 7.2 | |