grants_to

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

Overview

Name	grants_to
Type	Resource
Id	snowflake.grant.grants_to

Fields

Name	Datatype	Description
created_on	string
grant_option	boolean	Can grantee pass this privilege down?
granted_by_name	string	The role that granted this privilege to this grantee
granted_by_role_type	string	Type of role that granted this privilege to this grantee
grantee_name	string	Specific name of object being granted to
grantee_type	string	Entity type being granted to
privileges	array	Privilege type
securable_name	string	Name of specific object granted on (not name of privilege!)
securable_type	string	Type of object granted on

Methods

Name	Accessible by	Required Params	Description
list_grants_to	SELECT	granteeName, granteeType, endpoint	List the roles and privileges granted to the specified grantee using the output of SHOW GRANTS TO

SELECT examples

List the roles and privileges granted to the specified grantee using the output of SHOW GRANTS TO

SELECT
created_on,
grant_option,
granted_by_name,
granted_by_role_type,
grantee_name,
grantee_type,
privileges,
securable_name,
securable_type
FROM snowflake.grant.grants_to
WHERE granteeName = '{{ granteeName }}'
AND granteeType = '{{ granteeType }}'
AND endpoint = '{{ endpoint }}';