The SA_SYSDBA.DROP_POLICY procedure drops a policy and its associated user and data labels from the database.
This procedure completely clears the policy and its associations in the system. You can choose to drop the label columns from all tables controlled by the policy.
Syntax
SA_SYSDBA.DROP_POLICY (
policy_name IN VARCHAR,
drop_column IN BOOLEAN := FALSE);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The policy to be dropped. You can query the POLICY_NAME column of the ALL_SA_POLICIES view for existing policies. |
| drop_column | Indicates whether to drop the policy column from protected tables. The default value is FALSE, which indicates not to drop the policy column. |
Examples
Drop the shield_agent_policy policy.
EXEC SA_SYSDBA.DROP_POLICY ('shield_agent_policy');