Grant
Grant the specified privilege(s) on the named securable to the named grantee (Deprecated)¶
POST/api/v2/grants/{granteeType}/{granteeName}/{securableType}/{securableName}/privileges
Endpoint to indicate that the privileges listed in the request body should be granted.
Path Parameters¶
Parameter | Description |
---|---|
granteeType string | String that specifies the type of resource that is the privilege grantee. |
granteeName string | String that specifies the name of the privilege grantee. |
securableType string | String that specifies the type of resource that is being secured by a privilege. |
securableName string | String that specifies the name of resource that is being secured by a privilege. |
Response¶
Code | Description |
---|---|
200 | Successful request. |
202 | Successfully accepted the request, but it is not completed yet. |
Grant the specified privilege(s) on all/future (as specified by bulkGrantType) securables of this type in a given scope to the named grantee (Deprecated)¶
POST/api/v2/grants/{granteeType}/{granteeName}/{bulkGrantType}/{securableTypePlural}/{scopeType}/{scopeName}/privileges
Endpoint to indicate that the privileges listed in the request body should be granted to all securables of this type in the given scope.
Path Parameters¶
Parameter | Description |
---|---|
granteeType string | String that specifies the type of resource that is the privilege grantee. |
granteeName string | String that specifies the name of the privilege grantee. |
bulkGrantType string | String that species whether this group privilege should be on ALL or FUTURE resources of the specified plural type |
securableTypePlural string | String that specifies the plural of the type of resource that is being secured by an ALL/FUTURE privilege. Must be either "schemas" or any plural object type that can nest under a schema such as "tables" |
scopeType string | String that specifies the type of resource that is the scope of an ALL/FUTURE privilege. Can only be DATABASE or SCHEMA |
scopeName string | String that specifies the name of resource that is the scope of an ALL/FUTURE privilege |
Response¶
Code | Description |
---|---|
200 | Successful request. |
202 | Successfully accepted the request, but it is not completed yet. |
Revoke the specified privilege on the named securable from the named grantee (Deprecated)¶
DELETE/api/v2/grants/{granteeType}/{granteeName}/{securableType}/{securableName}/privileges/{privilege}
Endpoint to indicate that the privilege listed in the path should be revoked.
Path Parameters¶
Parameter | Description |
---|---|
granteeType string | String that specifies the type of resource that is the privilege grantee. |
granteeName string | String that specifies the name of the privilege grantee. |
securableType string | String that specifies the type of resource that is being secured by a privilege. |
securableName string | String that specifies the name of resource that is being secured by a privilege. |
privilege string | String that specifies a privilege to be revoked |
Query Parameters¶
Parameter | Description |
---|---|
deleteMode string | If "cascade", recursively revoke the grant from sub-grantees to which this privilege was re-granted. Acceptable values are "restrict" or "cascade". |
Response¶
Code | Description |
---|---|
200 | Successful request. |
202 | Successfully accepted the request, but it is not completed yet. |
Revoke the grant option for the specified privilege on the named securable from the named grantee (Deprecated)¶
DELETE/api/v2/grants/{granteeType}/{granteeName}/{securableType}/{securableName}/privileges/{privilege}/grant-option
Endpoint to indicate that the grant option for the privilege listed in the path should be revoked.
Path Parameters¶
Parameter | Description |
---|---|
granteeType string | String that specifies the type of resource that is the privilege grantee. |
granteeName string | String that specifies the name of the privilege grantee. |
securableType string | String that specifies the type of resource that is being secured by a privilege. |
securableName string | String that specifies the name of resource that is being secured by a privilege. |
privilege string | String that specifies a privilege to be revoked |
Query Parameters¶
Parameter | Description |
---|---|
deleteMode string | If "cascade", recursively revoke the grant from sub-grantees to which this privilege was re-granted. Acceptable values are "restrict" or "cascade". |
Response¶
Code | Description |
---|---|
200 | Successful request. |
202 | Successfully accepted the request, but it is not completed yet. |
Revoke the specified privilege on the specified all/future securable in the given scope from the named grantee (Deprecated)¶
DELETE/api/v2/grants/{granteeType}/{granteeName}/{bulkGrantType}/{securableTypePlural}/{scopeType}/{scopeName}/privileges/{privilege}
Endpoint to indicate that the privilege listed on the group securable in the given scope should be revoked.
Path Parameters¶
Parameter | Description |
---|---|
granteeType string | String that specifies the type of resource that is the privilege grantee. |
granteeName string | String that specifies the name of the privilege grantee. |
bulkGrantType string | String that species whether this group privilege should be on ALL or FUTURE resources of the specified plural type |
securableTypePlural string | String that specifies the plural of the type of resource that is being secured by an ALL/FUTURE privilege. Must be either "schemas" or any plural object type that can nest under a schema such as "tables" |
scopeType string | String that specifies the type of resource that is the scope of an ALL/FUTURE privilege. Can only be DATABASE or SCHEMA |
scopeName string | String that specifies the name of resource that is the scope of an ALL/FUTURE privilege |
privilege string | String that specifies a privilege to be revoked |
Query Parameters¶
Parameter | Description |
---|---|
deleteMode string | If "cascade", recursively revoke the grant from sub-grantees to which this privilege was re-granted. Acceptable values are "restrict" or "cascade". |
Response¶
Code | Description |
---|---|
200 | Successful request. |
202 | Successfully accepted the request, but it is not completed yet. |
Revoke the grant option for the specified privilege on the specified all/future securable in the given scope from the named grantee (Deprecated)¶
DELETE/api/v2/grants/{granteeType}/{granteeName}/{bulkGrantType}/{securableTypePlural}/{scopeType}/{scopeName}/privileges/{privilege}/grant-option
Endpoint to indicate that the grant option for the privilege listed on the group securable in the given scope should be revoked.
Path Parameters¶
Parameter | Description |
---|---|
granteeType string | String that specifies the type of resource that is the privilege grantee. |
granteeName string | String that specifies the name of the privilege grantee. |
bulkGrantType string | String that species whether this group privilege should be on ALL or FUTURE resources of the specified plural type |
securableTypePlural string | String that specifies the plural of the type of resource that is being secured by an ALL/FUTURE privilege. Must be either "schemas" or any plural object type that can nest under a schema such as "tables" |
scopeType string | String that specifies the type of resource that is the scope of an ALL/FUTURE privilege. Can only be DATABASE or SCHEMA |
scopeName string | String that specifies the name of resource that is the scope of an ALL/FUTURE privilege |
privilege string | String that specifies a privilege to be revoked |
Query Parameters¶
Parameter | Description |
---|---|
deleteMode string | If "cascade", recursively revoke the grant from sub-grantees to which this privilege was re-granted. Acceptable values are "restrict" or "cascade". |
Response¶
Code | Description |
---|---|
200 | Successful request. |
202 | Successfully accepted the request, but it is not completed yet. |
List of privileges associated with this grantee type and name (Deprecated)¶
GET/api/v2/grants/{granteeType}/{granteeName}
List the roles and privileges granted to the specified grantee using the output of SHOW GRANTS TO
Path Parameters¶
Parameter | Description |
---|---|
granteeType string | String that specifies the type of resource that is the privilege grantee. |
granteeName string | String that specifies the name of the privilege grantee. |
Query Parameters¶
Parameter | Description |
---|---|
showLimit integer | Query parameter to limit the maximum number of rows returned by a command. |
Response¶
Code | Description |
---|---|
200 | successful |
202 | Successfully accepted the request, but it is not completed yet. |