The SA_SYSDBA package manages label security policies, such as creating, altering, and dropping label security policies.
To use this PL package, you must be granted the EXECUTE privilege on it. The SA_SYSDBA package is the rights package of an invoker. Before you use this package, you must grant the SYS user the INHERIT PRIVILEGES privilege:
GRANT INHERIT PRIVILEGES ON USER SYS TO LBACSYS;
You need to grant this privilege only to the SYS user.
The following table describes the stored procedures provided in the SA_SYSDBA package and supported by the current OceanBase Database version.
| Stored procedure | Description |
|---|---|
| SA_SYSDBA.ALTER_POLICY | Alters a label security policy. |
| SA_SYSDBA.CREATE_POLICY | Creates a label security policy. |
| SA_SYSDBA.DROP_POLICY | Drops a label security policy. |
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.