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

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

Website Navigation

• Reference
• SQL command reference
• Security

DESCRIBE FEATURE POLICY | Snowflake Documentation

Describes the properties of a feature policy.

DESCRIBE can be abbreviated to DESC.

See also:

CREATE FEATURE POLICY , ALTER FEATURE POLICY, DROP FEATURE POLICY, SHOW FEATURE POLICIES

{ DESC | DESCRIBE } FEATURE POLICY <name>

Copy

name

Specifies the identifier for the feature policy to describe.

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.

The command displays properties of a feature policy in the following columns:

Column

Description

property

The name of the feature property policy. This column can include the properties listed in the following table.

value

The value assigned to the property of the feature policy.

The property column can include the following properties of a feature policy:

Property

Description

created_on

The timestamp when the feature policy was created.

name

The name of the feature policy.

owner

The role that owns the feature policy.

owner_role_type

The type of role that owns the object: ROLE or DATABASE_ROLE

comment

A description of the feature policy.

blocked_object_types_for_creation

The list of objects that the feature policy blocks for creation.

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

Privilege

Object

Notes

APPLY FEATURE POLICY

Account

OWNERSHIP or APPLY

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.

The following example describes the feature policy named block_db_policy:

DESCRIBE FEATURE POLICY block_db_policy;

Copy

+------------------------------------+-------------------------------+
| property                           | value                         |
+------------------------------------|-------------------------------+
| created_on                         | 2025-05-23 08:19:49.483 -0700 |
| name                               | BLOCK_CREATE_DB_POLICY        |
| owner                              | ACCOUNTADMIN                  |
| owner_role_type                    | ROLE                          |
| comment                            |                               |
| blocked_object_types_for_creation  | DATABASES                     |
+------------------------------------+-------------------------------+

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