FutureGrant

Snowflake Documentation

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

Examples

Python

# Database Object Privs:
future_grant = FutureGrant(
    priv="CREATE TABLE",
    on_future_schemas_in=Database(name="somedb"),
    to="somerole",
)
future_grant = FutureGrant(
    priv="CREATE TABLE",
    on_future_schemas_in_database="somedb",
    to="somerole",
)
# Schema Object Privs:
future_grant = FutureGrant(
    priv="SELECT",
    on_future_tables_in=Schema(name="someschema"),
    to="somerole",
)
future_grant = FutureGrant(
    priv="READ",
    on_future_image_repositories_in_schema="someschema",
    to="somerole",
)

YAML

future_grants:
  - priv: SELECT
    on_future_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 privilege is 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.