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. To drop a policy ON METASTORE (Beta), you must be a metastore admin.

Syntax​

DROP POLICY policy_name
ON { METASTORE | 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;
On this page