The SA_POLICY_ADMIN.ENABLE_TABLE_POLICY procedure reenables the current enforcement options, labeling features, and predicates for a specified table.
This stored procedure achieves this by reapplying row-level security predicates and DML triggers.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
SA_POLICY_ADMIN.ENABLE_TABLE_POLICY (
policy_name IN VARCHAR,
schema_name IN VARCHAR,
table_name IN VARCHAR);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The name of the policy. To find existing policies, query the POLICY_NAME and STATUS columns of the ALL_SA_POLICIES data dictionary view. |
| schema_name | The schema in which this table resides. To find this schema, query the POLICY_NAME and SCHEMA_NAME columns of the ALL_SA_TABLE_POLICIES view. |
| table_name | The table in the database named schema_name. To find this table, query the POLICY_NAME, SCHEMA_NAME, and TABLE_NAME columns of the ALL_SA_TABLE_POLICIES view. |
Examples
The following example enables the shield_agent_policy policy on the MISSION_LIST table in the FURY schema:
BEGIN
SA_POLICY_ADMIN.ENABLE_TABLE_POLICY(
policy_name => 'shield_agent_policy',
schema_name => 'FURY',
table_name => 'MISSION_LIST');
END;
/