Skip to main content
Last updated on

DROP POLICY

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 16.4 and above check marked yes Unity Catalog only

Deletes a named policy from a securable.

To run this statement, you must have the MANAGE privilege on the target securable.

Syntax​

DROP POLICY policy_name
ON { CATALOG catalog_name | SCHEMA schema_name | TABLE table_name }

Parameters​

  • policy_name

    The name of the policy to drop. If the policy does not exist on the securable, Databricks raises POLICY_NOT_FOUND.

  • catalog_name

    The name of the catalog on which the policy is defined.

  • schema_name

    The name of the schema on which the policy is defined.

  • table_name

    The name of the table on which the policy is defined.

Examples​

SQL
> DROP POLICY ssn_mask ON CATALOG employees;
> DROP POLICY hide_eu_customers ON SCHEMA prod.customers;