grant_options

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

Overview

Name	grant_options
Type	Resource
Id	snowflake.grant.grant_options

Fields

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

Methods

Name	Accessible by	Required Params	Description
revoke_group_privilege_grant_option	DELETE	bulkGrantType, granteeName, granteeType, privilege, scopeName, scopeType, securableTypePlural, endpoint	Endpoint to indicate that the grant option for the privilege listed on the group securable in the given scope should be revoked.
revoke_privilege_grant_option	DELETE	granteeName, granteeType, privilege, securableName, securableType, endpoint	Endpoint to indicate that the grant option for the privilege listed in the path should be revoked.

DELETE example

Deletes the specified grant_options resource.

/*+ delete */
DELETE FROM snowflake.grant.grant_options
WHERE granteeName = '{{ granteeName }}'
AND granteeType = '{{ granteeType }}'
AND privilege = '{{ privilege }}'
AND securableName = '{{ securableName }}'
AND securableType = '{{ securableType }}'
AND endpoint = '{{ endpoint }}';