Snowflake · Schema

Grant

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name	Type	Description
securable_type	string	Type of the securable to be granted. Only ROLE is supported
privileges	array	List of privileges to be granted.
created_on	string	Date and time when the grant was created
granted_by	string	The role that granted this privilege to this grantee

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Grant",
  "type": "object",
  "properties": {
    "securable_type": {
      "type": "string",
      "description": "Type of the securable to be granted. Only ROLE is supported"
    },
    "privileges": {
      "type": "array",
      "description": "List of privileges to be granted."
    },
    "created_on": {
      "type": "string",
      "description": "Date and time when the grant was created"
    },
    "granted_by": {
      "type": "string",
      "description": "The role that granted this privilege to this grantee"
    }
  }
}