DESCRIBE FEATURE POLICY¶

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

Syntax¶

{ DESC | DESCRIBE } FEATURE POLICY <name>

Copy

Parameters¶

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.

Output¶

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.

Access control requirements¶

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.

Examples¶

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                     |
+------------------------------------+-------------------------------+