The SA_SYSDBA.DROP_POLICY procedure is used to drop a policy and its associated user labels and data labels from the database.
This procedure completely removes the policy and its associated elements. 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 provides only MySQL-compatible mode.
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 dropped. 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, meaning the policy column is not dropped. |
Examples
The following example drops the shield_agent_policy policy.
EXEC SA_SYSDBA.DROP_POLICY ('shield_agent_policy');