DROP_POLICY Procedure

This procedure drops a fine-grained access control policy from a table or view.

The procedure causes the current transaction, if any, to commit before the operation is carried out. However, this does not cause a commit first if it is inside a DDL event trigger.

See Also: Usage Notes

A commit is also performed at the end of the operation.

Syntax

DBMS_RLS.DROP_POLICY (
   object_schema IN VARCHAR2 := NULL,
   object_name   IN VARCHAR2,
   policy_name   IN VARCHAR2); 

Parameters

Table 56-3 DROP_POLICY Procedure Parameters

Parameter	Description
object_schema	Schema containing the table or view (logon user if NULL).
object_name	Name of table or view.
policy_name	Name of policy to be dropped from the table or view.