Revoke the grant option on all or future objects
One step with Snowflake. We can help you get access.
Get something done
Revoke the grant option on all or future objects
with Snowflake · Identity & Access Management
Use Snowflake: its Snowflake Grant API lets you revoke the grant option on all or future objects in a single step (DELETE /api/v2/grants/{granteeType}/{granteeName}/{bulkGrantType}/{securableTypePlural}/{scopeType}/{scopeName}/privileges/{privilege}/grant-option). capabilities.work can help you get signed up and connected.
- Can I remove the grant option from a future grant but leave the privilege in place?
- What strips re-grant rights from a bulk grant across a whole schema?
Say it to your AI assistant
- For the bulk grant of {privilege} on {bulk} {securables} in {scope_type} {scope_name}, drop only the grant option held by {grantee_type} {grantee_name}.
- Stop {grantee_type} {grantee_name} re-granting {privilege} on {bulk} {securables} of {scope_type} {scope_name} ({mode}).
For your developer
DELETE /api/v2/grants/{granteeType}/{granteeName}/{bulkGrantType}/{securableTypePlural}/{scopeType}/{scopeName}/privileges/{privilege}/grant-option in Snowflake Grant API. Full spec on APIs.io.