DROP FEATURE POLICY¶

Removes the specified feature policy.

See also:: CREATE FEATURE POLICY , ALTER FEATURE POLICY, DESCRIBE FEATURE POLICY, SHOW FEATURE POLICIES

Syntax¶

DROP FEATURE POLICY <name>

Copy

Parameters¶

name: Specifies the identifier for the feature policy to drop.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

Access control requirements¶

A role used to execute this operation must have the following privileges at a minimum:

Privilege	Object	Notes
OWNERSHIP	Feature policy	This privilege is required to drop a feature policy.

The USAGE privilege on the parent database and schema are required to perform operations on any object in a schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage Notes¶

A feature policy can’t be dropped if it is currently applied to an object. Use the ALTER FEATURE POLICY command to un-apply the feature policy from the object, then drop the feature policy.

Examples¶

The following example drops the feature policy named block_db_policy:

DROP FEATURE POLICY block_db_policy;

Copy

+---------------------------------------+
| status                                |
|---------------------------------------|
| BLOCK_DB_POLICY successfully dropped. |
+---------------------------------------+