The SA_SYSDBA package is used to manage label security policies, such as creating, modifying, or dropping them.
To use this package, you must have the EXECUTE privilege. The SA_SYSDBA package is a privilege package for callers. Before using this package, you must grant the following INHERIT PRIVILEGES to the SYS user:
GRANT INHERIT PRIVILEGES ON USER SYS TO LBACSYS;
You only need to grant this privilege to the SYS user; there is no need to grant it to other users.
The following table lists the contents of the SA_SYSDBA package supported by the current version of OceanBase Database.
stored procedure |
Description |
|---|---|
| SA_SYSDBA.ALTER_POLICY | Modify the tag security policy. |
| SA_SYSDBA.CREATE_POLICY | Create a tag security policy. |
| SA_SYSDBA.DROP_POLICY | Delete Tag Security Policy. |
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.