The SA_COMPONENTS.CREATE_LEVEL procedure creates a level and specifies its short name and long name.
The value assigned to the level_num parameter specifies the sensitivity level. A smaller value means a lower sensitivity level.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL 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 | The policy name. You can query the POLICY_NAME column of the ALL_SA_POLICIES data dictionary view for existing policies. |
| level_num | The level number, ranging from 0 to 9999. |
| short_name | The short name of the level, which can contain up to 30 characters in length. |
| long_name | The long name of the level, which can contain up to 80 characters in length. |
Examples
The following example creates a level for shield_agent_policy:
BEGIN
SA_COMPONENTS.CREATE_LEVEL (
policy_name => 'shield_agent_policy',
level_num => 500,
short_name => 'L5',
long_name => 'Level 5');
END;
/