The SA_SYSDBA.DROP_POLICY procedure is used to delete a policy and its associated user labels and data labels from the database.
This procedure completely removes the policy and its associations from the system. You can choose to drop the label column from all tables controlled by the policy.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
SA_SYSDBA.DROP_POLICY (
policy_name IN VARCHAR,
drop_column IN BOOLEAN := FALSE);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The name of the policy to be deleted. To find the list of existing policies, query the POLICY_NAME column of the ALL_SA_POLICIES view. |
| drop_column | Indicates whether to drop the policy column from protected tables. The default value is FALSE, which means the policy column will not be dropped. |
Examples
The following example deletes the shield_agent_policy policy.
EXEC SA_SYSDBA.DROP_POLICY ('shield_agent_policy');