SA_SESSION.LABEL

2025-11-19 10:08:13  Updated

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 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;

Contact Us