Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
Security
|
107
Auditing
Just as monitoring resource usage is an important way to
understand performance issues, auditing is a way to track
usage in the database and to become aware of potential secu-
rity issues.
For some time, Oracle has allowed three different types of
auditing:
Statement auditing
Audits the statements issued on the database for specific
users or for all users.
Privilege auditing
Audits the use of system privileges for specific users or
for all users.
Schema object auditing
Audits a specific set of SQL statements on a particular
schema object.
Oracle9i Database and Oracle Database 10g also allow a
fourth type of auditing, called fine-grained auditing, which is
explained later, in the “Fine-grained auditing” section.
For all types of auditing, Oracle writes audit records to one
of these locations: a database audit trail; the SYS.FGA_
LOG$ table; or an operating system file (in binary format).
The audit trail records contain different information,
depending on the type of auditing and the options set for the
auditing.
Whether or not auditing is enabled for your Oracle data-
base, the following actions always generate records for the
operating system audit trail:
Instance startup
Instance shutdown
Access by users with administrator privileges
108
|
Oracle DBA Pocket Guide
You enable and disable ...
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 PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843