The SA_SESSION.LABEL procedure returns the label associated with the specified policy for the current session.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
Syntax
SA_SESSION.LABEL (
policy_name IN VARCHAR)
RETURN VARCHAR AS
ret VARCHAR (4000);
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. |
Examples
The following example returns the label associated with shield_agent_policy:
SELECT SA_SESSION.LABEL ('shield_agent_policy') FROM DUAL;