Queries the permissions of users on a database.
Debugging
Authorization information
There is currently no authorization information disclosed in the API.
Request parameters
Parameter | Type | Required | Description | Example |
---|---|---|---|---|
Tid | long | No | The ID of the tenant. Note
: To view the ID of the tenant, log on to the Data Management (DMS) console and move the pointer over the profile picture in the upper-right corner. For more information, see Manage DMS tenants.
| -1 |
PermType | string | Yes | The type of the permission. Valid values:
| DATABASE |
DbId | string | Yes | The ID of the database. | 123 |
Logic | boolean | No | Specifies whether the database is a logical database. | false |
UserName | string | No | The nickname of the user. | search_user_name |
PageNumber | integer | No | The number of the page to return. | 1 |
PageSize | integer | No | The number of entries to return on each page. | 10 |
Response parameters
Examples
Sample success responses
JSON
format
{
"TotalCount": 1,
"RequestId": "68075D06-7406-4887-83A7-F558A4D28C13",
"ErrorCode": "UnknownError",
"ErrorMessage": "UnknownError",
"UserPermissions": {
"UserPermission": [
{
"DbId": "1234",
"TableName": "table_name",
"UserId": "14324",
"SchemaName": "xxx@xxxx:3306",
"Logic": false,
"UserNickName": "user_nick_name",
"InstanceId": "1443",
"PermDetails": {
"PermDetail": [
{
"OriginFrom": "xxx grant",
"PermType": "QUERY",
"ExpireDate": "2020-12-12 00:00:00",
"CreateDate": "2019-12-12 00:00:00",
"UserAccessId": "13434",
"ExtraData": "DEFAULT"
}
]
},
"EnvType": "product",
"ColumnName": "column_name",
"DbType": "mysql",
"DsType": "DATABASE",
"TableId": "42345",
"SearchName": "xxx",
"Alias": "instance_alias"
}
]
},
"Success": true
}
Error codes
For a list of error codes, visit the Service error codes.
Change history
Change time | Summary of changes | Operation |
---|
No change history