Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/sql/drop-feature-policy below:

DROP FEATURE POLICY | Snowflake Documentation

Removes the specified feature policy.

See also:

CREATE FEATURE POLICY , ALTER FEATURE POLICY, DESCRIBE FEATURE POLICY, SHOW FEATURE POLICIES

DROP FEATURE POLICY <name>

Copy

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.

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.

• 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.

The following example drops the feature policy named block_db_policy:

DROP FEATURE POLICY block_db_policy;

Copy

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

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4