Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RLS , 4 of 13
This procedure causes all the cached statements associated with the policy to be reparsed. This guarantees that the latest change to this policy will have immediate effect after the procedure is executed.
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.REFRESH_POLICY ( object_schema IN VARCHAR2 := NULL, object_name IN VARCHAR2 := NULL, policy_name IN VARCHAR2 := NULL);
Parameter | Description |
---|---|
object_schema |
Schema containing the table or view. |
object_name |
Name of table or view that the policy is associated with. |
policy_name |
Name of policy to be refreshed. |
The procedure returns an error if it tries to refresh a disabled policy.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|