Oracle PL/SQL for DBAs

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 ...