The CREATE_POLICY_GROUP procedure is used to create a policy group. The DELETE_POLICY_GROUP procedure is used to drop a policy group.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
CREATE_POLICY_GROUP
DBMS_RLS.CREATE_POLICY_GROUP(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2,
policy_group IN VARCHAR2);
DELETE_POLICY_GROUP
DBMS_RLS.DELETE_POLICY_GROUP(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2,
policy_group 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. |
| policy_group | The name of the policy group. |
Examples
-- Create Policy Group
BEGIN
DBMS_RLS.CREATE_POLICY_GROUP(
object_schema => 'hr',
object_name => 'employees',
policy_group => 'admin_group');
END;
/
-- Delete Policy Group
BEGIN
DBMS_RLS.DELETE_POLICY_GROUP(
object_schema => 'hr',
object_name => 'employees',
policy_group => 'admin_group');
END;
/