Managed Service for MySQL API, gRPC: UserService.RevokePermission
Revokes permission to access a database from a user in a cluster.
gRPC request
rpc RevokePermission (RevokeUserPermissionRequest) returns (operation.Operation)
RevokeUserPermissionRequest
{
"cluster_id": "string",
"user_name": "string",
"permission": {
"database_name": "string",
"roles": [
"Privilege"
]
}
}
Field |
Description |
cluster_id |
string Required field. ID of the cluster to revoke permission from the user in. To get this ID, make a ClusterService.List request. |
user_name |
string Required field. Name of the user to revoke permission from. To get this name, make a UserService.List request. |
permission |
Required field. Permission that should be revoked from the user. |
Permission
Field |
Description |
database_name |
string Name of the database that the permission grants access to. |
roles[] |
enum Privilege Roles granted to the user within the database. See the documentation for details.
|
operation.Operation
{
"id": "string",
"description": "string",
"created_at": "google.protobuf.Timestamp",
"created_by": "string",
"modified_at": "google.protobuf.Timestamp",
"done": "bool",
"metadata": {
"cluster_id": "string",
"user_name": "string"
},
// Includes only one of the fields `error`, `response`
"error": "google.rpc.Status",
"response": {
"name": "string",
"cluster_id": "string",
"permissions": [
{
"database_name": "string",
"roles": [
"Privilege"
]
}
],
"global_permissions": [
"GlobalPermission"
],
"connection_limits": {
"max_questions_per_hour": "google.protobuf.Int64Value",
"max_updates_per_hour": "google.protobuf.Int64Value",
"max_connections_per_hour": "google.protobuf.Int64Value",
"max_user_connections": "google.protobuf.Int64Value"
},
"authentication_plugin": "AuthPlugin"
}
// end of the list of possible fields
}
An Operation resource. For more information, see Operation.
Field |
Description |
id |
string ID of the operation. |
description |
string Description of the operation. 0-256 characters long. |
created_at |
Creation timestamp. |
created_by |
string ID of the user or service account who initiated the operation. |
modified_at |
The time when the Operation resource was last modified. |
done |
bool If the value is |
metadata |
Service-specific metadata associated with the operation. |
error |
The error result of the operation in case of failure or cancellation. Includes only one of the fields The operation result. |
response |
The normal response of the operation in case of success. Includes only one of the fields The operation result. |
RevokeUserPermissionMetadata
Field |
Description |
cluster_id |
string ID of the cluster the user is being revoked a permission in. |
user_name |
string Name of the user whose permission is being revoked. |
User
An object that represents MySQL user.
See the documentation for details.
Field |
Description |
name |
string Name of the user. |
cluster_id |
string ID of the cluster the user belongs to. |
permissions[] |
Set of permissions granted to the user. |
global_permissions[] |
enum GlobalPermission Set of global permissions to grant to the user.
|
connection_limits |
Set of user connection limits. |
authentication_plugin |
enum AuthPlugin User authentication plugin.
|
Permission
Field |
Description |
database_name |
string Name of the database that the permission grants access to. |
roles[] |
enum Privilege Roles granted to the user within the database. See the documentation for details.
|
ConnectionLimits
Field |
Description |
max_questions_per_hour |
The maximum permitted number of user questions per hour. |
max_updates_per_hour |
The maximum permitted number of user updates per hour. |
max_connections_per_hour |
The maximum permitted number of simultaneous client connections per hour. |
max_user_connections |
The maximum number of simultaneous connections permitted to any given MySQL user account. |