Snowflake · Schema

Grant

Properties of a grant that can be granted to a role or user.

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
privileges array Privilege type
grant_option boolean Can grantee pass this privilege down?
created_on string
grantee_type string Entity type being granted to
grantee_name string Specific name of object being granted to
securable_type string Type of object granted on
securable_name string Name of specific object granted on (not name of privilege!)
granted_by_role_type string Type of role that granted this privilege to this grantee
granted_by_name string The role that granted this privilege to this grantee
View JSON Schema on GitHub

JSON Schema

grant-grant-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Grant",
  "type": "object",
  "description": "Properties of a grant that can be granted to a role or user.",
  "properties": {
    "privileges": {
      "type": "array",
      "description": "Privilege type"
    },
    "grant_option": {
      "type": "boolean",
      "description": "Can grantee pass this privilege down?"
    },
    "created_on": {
      "type": "string"
    },
    "grantee_type": {
      "type": "string",
      "description": "Entity type being granted to"
    },
    "grantee_name": {
      "type": "string",
      "description": "Specific name of object being granted to"
    },
    "securable_type": {
      "type": "string",
      "description": "Type of object granted on"
    },
    "securable_name": {
      "type": "string",
      "description": "Name of specific object granted on (not name of privilege!)"
    },
    "granted_by_role_type": {
      "type": "string",
      "description": "Type of role that granted this privilege to this grantee"
    },
    "granted_by_name": {
      "type": "string",
      "description": "The role that granted this privilege to this grantee"
    }
  }
}