SHOW FEATURE POLICIES¶

Lists the feature policies for which you have access privileges.

See also:: CREATE FEATURE POLICY , ALTER FEATURE POLICY, DESCRIBE FEATURE POLICY, DROP FEATURE POLICY

语法

SHOW FEATURE POLICIES
  [ IN
    {
      ACCOUNT                                        |
      APPLICATION {app_name}                         |
      APPLICATION PACKAGE {app_package_name}         |
      DATABASE {database_name}                       |
      SCHEMA {schema_name}                           |
    }
  ]

SHOW FEATURE POLICIES ON ACCOUNT

SHOW FEATURE POLICIES ON APPLICATION <application_name>

参数

[ IN ... ]

（可选）指定命令的作用域。指定以下任一项：

ACCOUNT: 返回有关在指定账户中创建的功能策略的信息。
APPLICATION app_name: 返回有关在指定应用程序中创建的功能策略的信息。
APPLICATION PACKAGE app_package_name: 返回有关在指定应用程序包中创建的功能策略的信息。
DATABASE database_name: 返回有关在指定数据库中创建的功能策略的信息。
SCHEMA schema_name: 返回有关在指定架构中创建的功能策略的信息。

ON ACCOUNT

显示已应用于当前账户的功能策略。

ON APPLICATION app_name

显示已应用于指定应用程序的功能策略。此命令还显示从应用于账户的功能策略中继承的功能策略。

访问控制要求

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

权限	对象	备注
OWNERSHIP	功能策略	使用此命令需要此权限。

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent 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.

输出

Column	Description
`created_on`	The timestamp when the policy was created.
`name`	The name of the policy.
`database_name`	The name of the database containing the policy.
`schema_name`	The name of the schema containing the policy.
`kind`	The type of feature policy. Currently, only `FEATURE_POLICY` is supported.
`owner`	The role that owns the feature policy.
`comment`	A comment containing information about the policy.
`owner_role_type`	The type of the role that owns the feature policy.
`options`	Currently, always NULL.

示例

以下示例列出了您有权在当前账户中查看的功能策略：

SHOW FEATURE POLICIES;

The following example lists the feature policies that you have the privileges to view in an app named hello_snowflake_app:

SHOW FEATURE POLICIES IN APPLICATION hello_snowflake_app;

以下示例列出了已应用于当前账户的功能策略：

SHOW FEATURE POLICIES ON ACCOUNT