grant_options

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

Overview

Name	grant_options
Type	Resource
Id	snowflake.grants.grant_options

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
revoke	delete	grantee_type, grantee_name, securable_type, securable_name, privilege, endpoint	deleteMode	Endpoint to indicate that the grant option for the privilege listed in the path should be revoked.

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)
grantee_name	string	String that specifies the name of the privilege grantee.
grantee_type	string	String that specifies the type of resource that is the privilege grantee.
privilege	string	String that specifies a privilege to be revoked
securable_name	string	String that specifies the name of resource that is being secured by a privilege.
securable_type	string	String that specifies the type of resource that is being secured by a privilege.
deleteMode	string	If "cascade", recursively revoke the grant from sub-grantees to which this privilege was re-granted. Acceptable values are "restrict" or "cascade".

DELETE examples

revoke

Endpoint to indicate that the grant option for the privilege listed in the path should be revoked.

DELETE FROM snowflake.grants.grant_options
WHERE grantee_type = '{{ grantee_type }}' --required
AND grantee_name = '{{ grantee_name }}' --required
AND securable_type = '{{ securable_type }}' --required
AND securable_name = '{{ securable_name }}' --required
AND privilege = '{{ privilege }}' --required
AND endpoint = '{{ endpoint }}' --required
AND deleteMode = '{{ deleteMode }}'
;