The SA_COMPONENTS.CREATE_LEVEL procedure is used to create a level and specify its short name and long name.
The value assigned to the level_num parameter determines the sensitivity level (a smaller number indicates a lower sensitivity level).
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL-compatible mode.
Syntax
SA_COMPONENTS.CREATE_LEVEL (
policy_name IN VARCHAR,
level_num IN NUMBER,
short_name IN VARCHAR,
long_name IN VARCHAR );
Parameters
| Parameter | Description |
|---|---|
| policy_name | Specifies the policy. To find existing policies, query the POLICY_NAME column of the ALL_SA_POLICIES view. |
| level_num | Specifies the level number (0-9999). |
| short_name | Specifies the short name of the level (up to 30 characters). |
| long_name | Specifies the long name of the level (up to 80 characters). |
Examples
The following example creates a level for the shield_agent_policy policy.
BEGIN
SA_COMPONENTS.CREATE_LEVEL (
policy_name => 'shield_agent_policy',
level_num => 500,
short_name => 'L5',
long_name => 'Level 5');
END;
/