Manage grants¶

The SNOWFLAKE REST Grant API provides the following endpoints to manage Snowflake grants:

Snowflake Grant API endpoints¶

Endpoint

Description

POST /api/v2/grants/granteeType/granteeName/securableType/securableName/privileges

Grants privileges listed in the request body.

POST /api/v2/grants/granteeType/granteeName/bulkGrantType/securableTypePlural/scopeType/scopeName/privileges

Grants privileges listed in the request body to all securables of the specified type in the given scope.

DELETE /api/v2/grants/granteeType/granteeName/securableType/securableName/privileges/privilege

Revokes privileges listed in the path parameters.

DELETE /api/v2/grants/granteeType/granteeName/securableType/securableName/privileges/privilege/grant-option

Revokes the grant option for the privileges listed in the path parameters.

DELETE /api/v2/grants/granteeType/granteeName/bulkGrantType/securableTypePlural/scopeType/scopeName/privileges/privilege

Revokes the privilege listed on the group securable in the specified scope.

DELETE /api/v2/grants/granteeType/granteeName/bulkGrantType/securableTypePlural/scopeType/scopeName/privileges/privilege/grant-option

Revokes the grant option for the privilege listed on the group securable in the given scope.

GET /api/v2/grants/granteeType/granteeName

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

For reference documentation, see Snowflake Grant API reference.