role_grants_of

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

Overview

Name	role_grants_of
Type	Resource
Id	snowflake.roles.role_grants_of

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
grantee_name	string	The name of the grantee
created_on	string (date-time)	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
role	string	The name of the role

Methods

The following methods are available for this resource:

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

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
endpoint	string	Organization and account identifier (orgname-accountname) (default: orgname-accountname)
name	string	Identifier (i.e. name) for the resource.
showLimit	integer	Parameter to limit the maximum number of rows returned by a command.

SELECT examples

list

List all grants of the role

SELECT
grantee_name,
created_on,
granted_by,
granted_to,
role
FROM snowflake.roles.role_grants_of
WHERE name = '{{ name }}' -- required
AND endpoint = '{{ endpoint }}' -- required
AND showLimit = '{{ showLimit }}'
;