Name

DROP_POLICY

Synopsis

This procedure drops an FGA policy that was previously created on a table.

   

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 dropped

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.