The ENABLE_GROUPED_POLICY procedure is used to enable a policy in a specified policy group. The DISABLE_GROUPED_POLICY procedure is used to disable a policy in a specified policy group.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
ENABLE_GROUPED_POLICY
DBMS_RLS.ENABLE_GROUPED_POLICY(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2,
group_name IN VARCHAR2,
policy_name IN VARCHAR2,
enable IN BOOLEAN := TRUE);
DISABLE_GROUPED_POLICY
DBMS_RLS.DISABLE_GROUPED_POLICY(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2,
group_name IN VARCHAR2,
policy_name IN VARCHAR2);
Parameters
Parameter |
Description |
|---|---|
| object_schema | The name of the schema to which the table or view belongs. Default isNULL, indicating the current schema. |
| object_name | The name of the table or view. |
| group_name | The name of the policy group. |
| policy_name | Policy name. |
| enable | Set toTRUEEnable the policy,FALSEDisabled policy. Applicable only toENABLE_GROUPED_POLICY. |
Examples
-- Enable Grouping Strategy
BEGIN
DBMS_RLS.ENABLE_GROUPED_POLICY(
object_schema => 'hr',
object_name => 'employees',
group_name => 'admin_group',
policy_name => 'emp_dept_policy',
enable => TRUE);
END;
/
-- Disable Grouping Policy
BEGIN
DBMS_RLS.DISABLE_GROUPED_POLICY(
object_schema => 'hr',
object_name => 'employees',
group_name => 'admin_group',
policy_name => 'emp_dept_policy');
END;
/