Change database access permissions
Request
| Method | Request URI |
|---|---|
| PATCH | https://management.chinacloudapi.cn/subscriptions/{subscription-id}/resourceGroups/{resource-group-name}/providers/Microsoft.MySql/servers/{server-name}/databases/{database-name}/privileges/{user-name}?api-version=2015-09-01 |
URI parameter
None
Request header
| Request package header | Describe URI |
|---|---|
| x-ms-client-request-id | Optional An opaque value generated by the client, not to exceed 1KB of characters. We strongly recommend setting this value so that the server can use it to obtain the client’s activity information. |
Request body
You must specify parameters when you create or update the MySQL Database on Azure server. A JSON example is provided here:
{
"properties": { "level": 3 }
}
| Parameter name | Description |
|---|---|
| Level | Set permissions to 0, 1 or 3. 0 means “no access”, 1 means “can read”, and 3 means “can write”. |
Response
An HTTPS response comprises a status code, a response header, and a response body.
Status code
200 OK: Indicates that the server has returned successfully.
Response header
| Request package header | Describe URI |
|---|---|
| x-ms-client-request-id | Can uniquely identify the database request value The request ID is used to track the request information. |
Response body
A JSON example is provided here:
{
"id": "/subscriptions/{subscription-id}/resourceGroups/{resource-group-name}/providers/Microsoft.MySql/servers/{server-name}/databases/{database-name}/privileges/{user-name}",
"name": "{server-name}/{database-name}/{user-name}",
"type": "Microsoft.MySql/servers/databases/privileges",
"properties": { "level": 3 }
}