Revoke only the grant option on one object
One step with Snowflake. We can help you get access.
Get something done
Revoke only the grant option on one object
with Snowflake · Identity & Access Management
Use Snowflake: its Snowflake Grant API lets you revoke only the grant option on one object in a single step (DELETE /api/v2/grants/{granteeType}/{granteeName}/{securableType}/{securableName}/privileges/{privilege}/grant-option). capabilities.work can help you get signed up and connected.
- Can I stop a role from re-granting a privilege while letting it keep the privilege itself?
- What removes just the WITH GRANT OPTION from a privilege on a single object?
Say it to your AI assistant
- Revoke the grant option for {privilege} on {securable_type} {securable_name} from {grantee_type} {grantee_name}.
- Stop {grantee_type} {grantee_name} re-granting {privilege} on {securable_type} {securable_name}, delete mode {mode}.
For your developer
DELETE /api/v2/grants/{granteeType}/{granteeName}/{securableType}/{securableName}/privileges/{privilege}/grant-option in Snowflake Grant API. Full spec on APIs.io.