RoleGrant

Snowflake Documentation

Represents a grant of a role to another role or user in Snowflake.

Examples

YAML

role_grants:
  # Grant multiple roles to a role
  - to_role: analyst
    roles:
      - z_db__raw
      - z_db__analytics
      - z_wh__transforming

  # Grant multiple roles to a user
  - to_user: jane_doe
    roles:
      - analyst
      - developer

Python

# Grant to Role:
role_grant = RoleGrant(role="somerole", to_role="someotherrole")

# Grant to User:
role_grant = RoleGrant(role="somerole", to_user="someuser")

Fields

• to_role (string or Role) - The role to receive the grants.
• to_user (string or User) - The user to receive the grants.
• roles (list) - List of roles to grant to the target role or user.