Grant
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'.
Last updated