Name

DISABLE_POLICY

Synopsis

This procedure disables an FGA policy that was previously created on a table. The policy is not dropped, but its effect is disabled.

   

Oracle Database version

Parameter name

Datatype

Description

9i

10g

object_schema

VARCHAR2

Owner of the table 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 to be disabled

Yes

Yes

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.