Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

AUDIT

Synopsis

AUDIT sql_statement_clause | schema_object_clause 
        [BY SESSION | ACCESS] 
        [WHENEVER [NOT] SUCCESSFUL]

Enables auditing on your Oracle database.

Clauses

sql_statement_clause

This clause is used to specify statement and system privilege auditing and has the following syntax:

{[statement_option | ALL][, ...]} | 
        {[system_privilege | ALL PRIVILEGES] [, ...]}
        BY {proxy(, proxy ...,] ON BEHALF OF [{user [, user ...]} | ANY |
        {user[, user ...]}
schema_object_clause

This clause is used to specify schema object auditing and has the following syntax:

{object_option[, object_option ...] | ALL }
        ON {[schema.]object | DIRECTORY directory_name | DEFAULT }

Keywords

BY SESSION | ACCESS

Specifies whether you want an audit record written once for each session or for each time a particular type of access is attempted. All statement auditing and all privilege auditing on DDL statements can only be set BY ACCESS.

WHENEVER [NOT] SUCCESSFUL

Specifies whether to modify only successful or failed SQL statements. The only failed SQL statements that are audited with the NOT keyword are those that fail or result in errors based on insufficient privileges or that a referenced object does not exist. The default is to audit all statements, regardless of whether they succeed or fail for the reasons mentioned.

BY user

Specifies auditing on the basis of one or more usernames.

BY proxy ON BEHALF OF

Specifies auditing of actions taken by a proxy on behalf of a user. New with Oracle8i.

statement_option

The values ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page