Snowflake · Schema

Grant

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
securable_type string Type of the securable to be granted.
grant_option boolean If true, allows the recipient role to grant the privileges to other roles.
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

database-role-grant-schema.json Raw ↑ 
{
  "$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."
    },
    "grant_option": {
      "type": "boolean",
      "description": "If true, allows the recipient role to grant the privileges to other roles."
    },
    "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"
    }
  }
}