grants_on

Creates, updates, deletes, gets or lists a grants_on resource.

Overview

Name	grants_on
Type	Resource
Id	snowflake.role.grants_on

Fields

Name	Datatype	Description
name	string	The name of the role
created_on	string	Date and time when the grant was created
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
granted_on	string	The type of of the role
granted_to	string	The type of the grantee
grantee_name	string	The name of the grantee
privilege	string	The name of the privilege

Methods

Name	Accessible by	Required Params	Description
list_grants_on	SELECT	name, endpoint	List all grants on the role

SELECT examples

List all grants on the role

SELECT
name,
created_on,
grant_option,
granted_by,
granted_by_role_type,
granted_on,
granted_to,
grantee_name,
privilege
FROM snowflake.role.grants_on
WHERE name = '{{ name }}'
AND endpoint = '{{ endpoint }}';