grants_of

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

Overview

Name	grants_of
Type	Resource
Id	snowflake.role.grants_of

Fields

Name	Datatype	Description
created_on	string	Date and time when the grant was created
granted_by	string	The role that granted this role to this grantee
granted_to	string	The type of the grantee, can be USER or ROLE
grantee_name	string	The name of the grantee
role	string	The name of the role

Methods

Name	Accessible by	Required Params	Optional Params	Description
list_grants_of	SELECT	name, endpoint	showLimit	List all grants of the role

Optional Parameter Details

Name	Description	Type	Default
showLimit	Query parameter to limit the maximum number of rows returned by a command.	integer	-

SELECT examples

List all grants of the role

SELECT
created_on,
granted_by,
granted_to,
grantee_name,
role
FROM snowflake.role.grants_of
WHERE name = '{{ name }}'
AND endpoint = '{{ endpoint }}';