Lists the feature policies for which you have access privileges.
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>
Copy
Parameters¶[ IN ... ]
Optionally specifies the scope of the command. Specify one of the following:
ACCOUNT
Returns information about feature policies created in the specified account.
APPLICATION app_name
Returns information about feature policies created in the specified app.
APPLICATION PACKAGE app_package_name
Returns information about feature policies created in the specified application package.
DATABASE database_name
Returns information about feature policies created in the specified database.
SCHEMA schema_name
Returns information about feature policies created in the specified schema.
ON ACCOUNT
Shows the feature policies that have been applied to the current account.
ON APPLICATION app_name
Shows the feature policies that have been applied on the specified app. This command also displays feature policies that are inherited from those applied on the account.
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 use this command.
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.
Output¶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.
Examples¶The following example lists the feature policies that you have the privileges to view in the current account:
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;
Copy
The following example lists the feature policies that have been applied on the current account:
SHOW FEATURE POLICIES ON ACCOUNT
Copy
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