The SA_SYSDBA.DROP_POLICY procedure drops a policy and the user and data labels associated with the policy from the database.
This procedure purges the policy and these associations completely from the system. You can choose to drop the label columns from all tables controlled by the policy.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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
The following example drops the shield_agent_policy policy:
EXEC SA_SYSDBA.DROP_POLICY ('shield_agent_policy');