The SA_POLICY_ADMIN.DISABLE_TABLE_POLICY procedure disables the policy enforcement for a table.
The stored procedure does not change the enforcement options, labeling function, or predicate values. It removes row-level security predicates and DML triggers from all tables in the schema.
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 policy name. You can query the POLICY_NAME column of the ALL_SA_POLICIES data dictionary view for existing policies. |
| schema_name | The schema containing the table. You can query the POLICY_NAME and SCHEMA_NAME columns of the ALL_SA_TABLE_POLICIES view for this schema. |
| table_name | The table in the schema specified by SCHEMA_NAME. You can query the POLICY_NAME, SCHEMA_NAME, and TABLE_NAME columns of the ALL_SA_TABLE_POLICIES view for this table. |
Examples
Disable shield_agent_policy for 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;
/