Name

ADD_POLICY

Synopsis

This procedure adds an FGA policy on a table.

   

Oracle Database version

Parameter name

Datatype

Description

9i

10g

object_schema

VARCHAR2

Schema name whose tables are to be under FGA.

Yes

Yes

object_name

VARCHAR2

Name of the table on which FGA is enabled.

Yes

Yes

policy_name

VARCHAR2

Name of the policy.

Yes

Yes

audit_condition

VARCHAR2

Condition under which the audit trail will be generated (e.g., USER='SCOTT').

Yes

Yes

audit_column

VARCHAR2

Auditing will be triggered only if columns from this list are selected.

Yes

Yes

handler_schema

VARCHAR2

If the policy has a handler module, the owner of that module. Handler modules are either procedures or packages that execute automatically when the audit condition is satisfied.

Yes

Yes

handler_module

VARCHAR2

Name of the handler procedure or package.

Yes

Yes

enable

BOOLEAN

Indicates whether the policy is created as enabled. Default is enabled.

Yes

Yes

statement_types

VARCHAR2

Which types of statements are audited. Valid values are SELECT, INSERT, DELETE, and UPDATE.

No

Yes

audit_trail

BINARY_INTEGER

If you need to capture bind variables as well as SQL text, set this parameter to DB_EXTENDED (which is the default). Otherwise, set it to DB. In Oracle Database 10g Release 2, you can define another type—XML—that writes audit trails in XML format in the filesystem.

No

Yes

audit_column_opts

BINARY_INTEGER

When the parameter audit_column is set, auditing is triggered ...

Get Oracle PL/SQL for DBAs now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.