Managed Service for MySQL API, REST: User.get
Retrieves information about the specified user.
HTTP request
GET https://mdb.api.cloud.yandex.net/managed-mysql/v1/clusters/{clusterId}/users/{userName}
Path parameters
Parameter | Description |
---|---|
clusterId | Required. ID of the cluster the user belongs to. To get this ID, make a list request. The maximum string length in characters is 50. |
userName | Required. Name of the user to return information about. To get this name, make a list request. The maximum string length in characters is 63. Value must match the regular expression |
Response
HTTP Code: 200 - OK
{
"name": "string",
"clusterId": "string",
"permissions": [
{
"databaseName": "string",
"roles": [
"string"
]
}
],
"globalPermissions": [
"string"
],
"connectionLimits": {
"maxQuestionsPerHour": "integer",
"maxUpdatesPerHour": "integer",
"maxConnectionsPerHour": "integer",
"maxUserConnections": "integer"
},
"authenticationPlugin": "string"
}
An object that represents MySQL user.
See the documentation for details.
Field | Description |
---|---|
name | string Name of the user. |
clusterId | string ID of the cluster the user belongs to. |
permissions[] | object Set of permissions granted to the user. |
permissions[]. databaseName |
string Name of the database that the permission grants access to. |
permissions[]. roles[] |
string Required. Roles granted to the user within the database. See the documentation for details. The minimum number of elements is 1.
|
globalPermissions[] | string Set of global permissions to grant to the user.
|
connectionLimits | object Set of user connection limits. |
connectionLimits. maxQuestionsPerHour |
integer (int64) The maximum permitted number of user questions per hour. The minimum value is 0. |
connectionLimits. maxUpdatesPerHour |
integer (int64) The maximum permitted number of user updates per hour. The minimum value is 0. |
connectionLimits. maxConnectionsPerHour |
integer (int64) The maximum permitted number of simultaneous client connections per hour. The minimum value is 0. |
connectionLimits. maxUserConnections |
integer (int64) The maximum number of simultaneous connections permitted to any given MySQL user account. The minimum value is 0. |
authenticationPlugin | string User authentication plugin.
|