Skip to Main Content
Oracle PL/SQL for DBAs
book

Oracle PL/SQL for DBAs

by Arup Nanda, Steven Feuerstein
October 2005
Intermediate to advanced content levelIntermediate to advanced
454 pages
14h 44m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL for DBAs

The DBA_AUDIT_POLICIES View

To see the FGA policies that have already been defined in the database, you can query the data dictionary view DBA_AUDIT_POLICIES, which contains the following columns:

OBJECT_SCHEMA

Name of the schema that owns the table or view on which the policy has been defined.

OBJECT_NAME

Name of the table or view on which the policy has been defined.

POLICY_NAME

Name of the policy.

POLICY_TEXT

If the policy has a condition—for example, “SALARY>=150000 OR EMPID=100”—it is shown here.

POLICY_COLUMN

If the policy has relevant columns (e.g., the audit trail is generated only if the relevant columns are referenced), they are shown here.

PF_SCHEMA

If a policy has a handler module, its owner’s name is shown here.

PF_FUNCTION

If the handler module is defined and is a standalone procedure, its name is shown here. If the handler module is a packaged procedure, the name of the procedure is shown here and the name of the package is shown in the column PF_PACKAGE.

PF_PACKAGE

See the description of PF_FUNCTION above.

ENABLED

Indicates whether the policy is enabled (YES or NO).

In Oracle Database 10g, this view has several additional columns:

SEL
INS
UPD
DEL
AUDIT_TRAIL
POLICY_COLUMN_OPTIONS

These are described later in the "FGA in Oracle Database 10g" section.

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 Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 0596005873Supplemental ContentErrata Page