ENABLE__GROUPED_POLICY Procedure

This procedure enables or disables a row-level group security policy.

Syntax

DBMS_RLS.ENABLE_GROUPED_POLICY (
   object_schema   VARCHAR2,
   object_name     VARCHAR2,
   group_name      VARCHAR2,
   policy_name     VARCHAR2,
   enable          BOOLEAN  ); 

Parameters

Table 56-12 ENABLE_GROUPED_POLICY Procedure Parameters

Parameter	Description
object_schema	The schema containing the table or view.
object_name	The name of the table or view with which the policy is associated.
group_name	The name of the group of the policy.
policy_name	The name of the policy to be enabled or disabled.
enable	TRUE enables the policy; FALSE disables the policy.

Usage Notes

• The procedure causes the current transaction, if any, to commit before the operation is carried out.

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

• A policy is enabled when it is created.