O'Reilly logo

Oracle Database Administration: The Essential Refe by Brian Laskey, David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

System Privilege Auditing

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.

AUDIT system_privilege [,system_privilege ...]
   [BY user[,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.

Table 7-4. System Privilege Auditing Shortcuts

System Privilege Shortcut

System Privileges Represented

CONNECT

CREATE SESSION

RESOURCE

ALTER SESSION

CREATE CLUSTER

CREATE DATABASE LINK

CREATE PROCEDURE

CREATE ROLLBACK SEGMENT

CREATE SEQUENCE

CREATE SYNONYM

CREATE TABLE

CREATE TABLESPACE

CREATE VIEW

DBA

SYSTEM GRANT statement option

AUDIT SYSTEM

CREATE PUBLIC DATABASE LINK

CREATE PUBLIC SYNONYM

CREATE ROLE

CREATE USER

ALL

Equivalent to all SQL statement options in Table 7.2

ALL PRIVILEGES

Equivalent to all system privileges

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required