The SA_POLICY_ADMIN package manages label security policies as a whole.
To use the SA_POLICY_ADMIN package, you must be granted the EXECUTE privilege on it.
The following table describes the stored procedures provided in the SA_POLICY_ADMIN package and supported by the current OceanBase Database version.
| Stored procedure | Description |
|---|---|
| SA_POLICY_ADMIN.APPLY_TABLE_POLICY | Adds the specified policy to a table. |
| SA_POLICY_ADMIN.DISABLE_TABLE_POLICY | Disables all the default policy enforcement options in the specified table without changing these options, the labeling function, or predicate values. |
| SA_POLICY_ADMIN.ENABLE_TABLE_POLICY | Reapplies the RLS predicate and DML triggers to re-enable the current enforcement options, labeling function, and predicate for the specified table. |
| SA_POLICY_ADMIN.REMOVE_TABLE_POLICY | Removes the specified policy from a table. |
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.