The SA_SESSION package manages session behaviors for user authorizations. Users can change labels during a session within the authorization scope configured by the administrator.
You can use this PL package without particular privileges.
The following table describes the stored procedures provided in the SA_SESSION package and supported by the current OceanBase Database version.
| Stored procedure | Description |
|---|---|
| SA_SESSION.LABEL | Returns the label associated with the specified label security policy. |
| SA_SESSION.RESTORE_DEFAULT_LABELS | Restores the current session label and row label to the stored default settings. |
| SA_SESSION.ROW_LABEL | Returns the name of the row label associated with the policy for the current session. |
| SA_SESSION.SET_LABEL | Sets a new level to which other users have the read access. |
| SA_SESSION.SET_ROW_LABEL | Sets the default row label that will be applied to new rows. |
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.