The SA_SESSION.RESTORE_DEFAULT_LABELS procedure restores the session labels and row labels to labels stored in the data dictionary.
You can use this procedure to reset values after you execute the SA_SESSION.SET_LABEL procedure.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
SA_SESSION.RESTORE_DEFAULT_LABELS (
policy_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. |
Examples
The following example restores the default label of shield_agent_policy:
BEGIN
SA_SESSION.RESTORE_DEFAULT_LABELS (
policy_name => 'shield_agent_policy');
END;
/