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 command to reset values after you execute the SA_SESSION.SET_LABEL command.
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
Restore the default label of shield_agent_policy.
BEGIN
SA_SESSION.RESTORE_DEFAULT_LABELS (
policy_name => 'shield_agent_policy');
END;
/