Method 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 [a-zA-Z0-9_]* . |
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
Some See MySQL documentation for details.
|
globalPermissions[] | string
The privilege enables use of |
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.
|