The SA_POLICY_ADMIN.DISABLE_TABLE_POLICY procedure disables the enforcement of a policy on a table.
This stored procedure does not change the enforcement option, label function, or predicate value. It removes row-level security predicates and DML triggers from all tables in the schema.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
SA_POLICY_ADMIN.DISABLE_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 column of the ALL_SA_POLICIES data dictionary view. |
| schema_name | The schema that contains the table. To find the schema, query the SCHEMA_NAME column of the ALL_SA_TABLE_POLICIES view. |
| table_name | The table in the schema specified by SCHEMA_NAME. To find the table, query the TABLE_NAME column of the ALL_SA_TABLE_POLICIES view. |
Examples
The following example disables the shield_agent_policy policy on the MISSION_LIST table in the FURY schema:
BEGIN
SA_POLICY_ADMIN.DISABLE_TABLE_POLICY(
policy_name => 'shield_agent_policy',
schema_name => 'FURY',
table_name => 'MISSION_LIST');
END;
/