Snowflake · Schema

GrantOn

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
created_on string Date and time when the grant was created
privilege string The name of the privilege
granted_on string The type of of the role
name string The name of the role
granted_to string The type of the grantee
grantee_name string The name of the grantee
grant_option string If true, allows the recipient role to grant the privileges to other roles.
granted_by string The role that granted this privilege to this grantee
granted_by_role_type string Type of the role that granted this privilege to this grantee
View JSON Schema on GitHub

JSON Schema

role-grant-on-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "GrantOn",
  "type": "object",
  "properties": {
    "created_on": {
      "type": "string",
      "description": "Date and time when the grant was created"
    },
    "privilege": {
      "type": "string",
      "description": "The name of the privilege"
    },
    "granted_on": {
      "type": "string",
      "description": "The type of of the role"
    },
    "name": {
      "type": "string",
      "description": "The name of the role"
    },
    "granted_to": {
      "type": "string",
      "description": "The type of the grantee"
    },
    "grantee_name": {
      "type": "string",
      "description": "The name of the grantee"
    },
    "grant_option": {
      "type": "string",
      "description": "If true, allows the recipient role to grant the privileges to other roles."
    },
    "granted_by": {
      "type": "string",
      "description": "The role that granted this privilege to this grantee"
    },
    "granted_by_role_type": {
      "type": "string",
      "description": "Type of the role that granted this privilege to this grantee"
    }
  }
}