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. |
+---------------------------------------+
Language: English