The SA_COMPONENTS.DROP_LEVEL procedure drops a level.
A level that is used in an existing label cannot be dropped.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
SA_COMPONENTS.DROP_LEVEL (
policy_name IN VARCHAR,
level_num IN NUMBER
);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The policy name. You can query the POLICY_NAME column of the ALL_SA_POLICIES data dictionary view for existing policies. |
| level_num | The number of an existing level of the policy. You can query the LEVEL_NUM column of the ALL_SA_LEVEL view for existing level numbers. |
Examples
The following example drops the level whose number is 500 for the shield_agent_policy policy:
BEGIN
SA_COMPONENTS.DROP_LEVEL (
policy_name => 'shield_agent_policy',
level_num => 500);
END;
/