GrantOnAll

Snowflake Documentation

Represents a grant of privileges on all resources of a specified type to a role in Snowflake.

Examples

Python

    # Schema Privs:
    grant_on_all = GrantOnAll(
        priv="CREATE TABLE",
        on_all_schemas_in_database="somedb",
        to="somerole",
    )
    grant_on_all = GrantOnAll(
        priv="CREATE VIEW",
        on_all_schemas_in=Database(name="somedb"),
        to="somerole",
    )
    # Schema Object Privs:
    grant_on_all = GrantOnAll(
        priv="SELECT",
        on_all_tables_in_schema="someschema",
        to="somerole",
    )
    grant_on_all = GrantOnAll(
        priv="SELECT",
        on_all_views_in_database="somedb",
        to="somerole",
    )

YAML

grants_on_all:
    - priv: SELECT
        on_all_tables_in_schema: someschema
        to: somerole

Fields

• priv (string, required) - The privilege to grant. Examples include 'SELECT', 'INSERT', 'CREATE TABLE'.

• on_type (string or ResourceType, required) - The type of resource on which the privileges are granted.
• in_type (string or ResourceType, required) - The type of container resource in which the privilege is granted.
• in_name (string, required) - The name of the container resource in which the privilege is granted.

• to (string or Role, required) - The role to which the privileges are granted.
• grant_option (bool) - Specifies whether the grantee can grant the privileges to other roles. Defaults to False.