Grant

Snowflake Documentation

Represents a grant of privileges on a resource to a role in Snowflake.

Examples

Python

# Global Privs:
grant = Grant(priv="CREATE WAREHOUSE", on="ACCOUNT", to="somerole")
# Warehouse Privs:
grant = Grant(priv="OPERATE", on=Warehouse(name="foo"), to="somerole")
grant = Grant(priv="OPERATE", on_warehouse="foo", to="somerole")
# Schema Privs:
grant = Grant(priv="CREATE TABLE", on=Schema(name="foo"), to="somerole")
grant = Grant(priv="CREATE TABLE", on_schema="foo", to="somerole")
# Table Privs:
grant = Grant(priv="SELECT", on_table="sometable", to="somerole")

YAML

- Grant:
    priv: "SELECT"
    on_table: "some_table"
    to: "some_role"
    grant_option: true

Fields

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

• on (string or Resource, required) - The resource on which the privilege is granted. Can be a string like 'ACCOUNT' or a specific resource object.
• 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.

• owner (string or Role) - The owner role of the grant. Defaults to 'SYSADMIN'.