Method get
Статья создана
Returns the specified SQL Server user.
To get the list of available SQL Server users, make a list request.
HTTP request
GET https://mdb.api.cloud.yandex.net/mdb/sqlserver/v1/clusters/{clusterId}/users/{userName}
Path parameters
| Parameter | Description |
|---|---|
| clusterId | Required. ID of the SQL Server cluster the user belongs to. To get the cluster ID, use a list request. The maximum string length in characters is 50. |
| userName | Required. Name of the SQL Server user to return. To get the name of the user use 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"
]
}
]
}
An SQL Server user.
| Field | Description |
|---|---|
| name | string Name of the SQL Server user. |
| clusterId | string ID of the SQL Server cluster the user belongs to. |
| permissions[] | object Set of permissions granted to the user. |
| permissions[]. databaseName |
string Name of the database the permission grants access to. |
| permissions[]. roles[] |
string
|