SA_COMPONENTS.ALTER_LEVEL is used to change the short name and long name of a level.
Once a level number is defined, it cannot be changed. If a level is used in any existing tags, its short name cannot be changed, but its long name can be.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
SA_COMPONENTS.ALTER_LEVEL (
policy_name IN VARCHAR,
level_num IN NUMBER,
new_short_name IN VARCHAR := NULL,
new_long_name IN VARCHAR := NULL
);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The name of the policy. To find existing policies, query the POLICY_NAME column of the ALL_SA_POLICIES view. |
| level_num | The number of the level to be changed. To find existing levels, query the LEVEL_NUM column of the ALL_SA_LEVELS view. |
| new_short_name | The new short name of the level (up to 30 characters) |
| new_long_name | The new long name of the level (up to 80 characters) |
Examples
The following example changes the long name and short name of the shield_agent_policy policy level.
BEGIN
SA_COMPONENTS.ALTER_LEVEL (
policy_name => 'shield_agent_policy',
level_num => 500,
new_short_name => 'M5',
new_long_name => 'MEDIUM_SECRET 5');
END;
/