Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RLS , 3 of 13
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.
A commit is also performed at the end of the operation.
DBMS_RLS.DROP_POLICY ( object_schema IN VARCHAR2 := NULL, object_name IN VARCHAR2, policy_name IN VARCHAR2);
Parameter | Description |
---|---|
object_schema |
Schema containing the table or view (logon user if |
object_name |
Name of table or view. |
policy_name |
Name of policy to be dropped from the table or view. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|