Call GetPermApplyOrderDetail to obtain details about a ticket for a permission application.
This interface is applicable to obtaining: Database-permission , Table-permissions , sensitive column-permission .
Debugging
Parameters
Parameter | Type | Is it required? | Example | Description |
---|---|---|---|---|
OrderId | Long | Yes | 730000 |
The ticket number. |
Tid | Long | No | -1 |
The tenant has expired. Note The information of the tenant's chart is taken from the avatar in the upper-right
corner of the system. For more information, see View tenant information .
|
RegionId | String | No | cn-hangzhou |
Select the service region of the destination region to call this operation. For more information about the valid values, see switchegionfigure parameter description . Note select based on the location of the application nearby.
|
return data
Parameter | Type | Example | Description |
---|---|---|---|
RequestId | String | A4C4499E-5AC2-4318-9FCF-03E426781A04 |
The error message returned because the request already exists. |
Success | Boolean | true |
Whether the request is successful. |
ErrorMessage | String | UnknownError |
Error message. |
ErrorCode | String | UnknownError |
Error code. |
PermApplyOrderDetail | object |
The details about the permission application. |
|
Resources | Array of Resource |
The detailed list of resources. |
|
DatabaseInfo | object |
The information of the database. |
|
DbId | Long | 12345 |
The library has expired. |
Logic | Boolean | false |
indicates whether the database is a logical database. Valid values:
|
DbType | String | MySQL |
The type of the database. |
SearchName | String | test@xxxx:3306 |
The name of the database search. |
OwnerIds | Array of Long | 12345 |
Owner ID. |
OwnerNickNames | Array of String | test_user |
Owner nickname. |
EnvType | String | product |
The environment type of the instance. For more information, see instance environment description . |
TableInfo | object |
The table information. |
|
TableName | String | test_tb |
The name of the table. |
ColumnInfo | object |
The field information. |
|
TableName | String | test_tb |
The name of the table. |
ColumnName | String | test_col |
The name of the field. |
InstanceInfo | object |
The information of the instance. |
|
InstanceId | String | 12345 |
The instance has expired. |
SearchName | String | xxxx:3306 |
The search name. |
DbType | String | MySQL |
The type of the database. |
EnvType | String | product |
The environment type of the instance. For more information, see instance environment description . |
Host | String | xxxx |
The connection address. |
Port | Long | 3306 |
The connection port. |
OwnerIds | Array of Long | 12345 |
Owner ID. |
OwnerNickName | Array of String | test_owner |
Owner nickname. |
DbaId | Long | 12345 |
The error message returned because the instance has already expired. |
DbaNickName | String | test_dba |
The nickname of the account that owns the instance. |
PermType | Long | 7 |
The permission type. the values and descriptions are as follows:
|
Seconds | Long | 3600 |
The duration of the permission limit, in seconds. |
ApplyType | String | DB |
The type of the requested permission. the valid values and descriptions are as follows:
|
Examples
Sample requests
http(s)://dms-enterprise.aliyuncs.com/? srderlimit D=73000®ionid=-1&public request parameters
Sample success responses
XML
Format
HTTP/1.1 200 OK Content-Type:application/xml <GetPermApplyOrderDetailResponse> <PermApplyOrderDetail> <ApplyType>DB</ApplyType> <PermType>1</PermType> <Seconds>2592000</Seconds> <Resources> <DatabaseInfo> <SearchName>rds_db@rm-bpxxxxxxxxffxxxxxxi.mysql.rds.aliyuncs.com:3306</SearchName> <OwnerNickNames>gctest</OwnerNickNames> <DbId>1250000</DbId> <Logic>false</Logic> <EnvType>dev</EnvType> <DbType>mysql</DbType> <OwnerIds>120000</OwnerIds> </DatabaseInfo> <ColumnInfo/> <TableInfo/> <InstanceInfo/> </Resources> </PermApplyOrderDetail> <RequestId>806FBC5B-2AED-401C-9E00-0B91C1DB2F1A</RequestId> <Success>true</Success> </GetPermApplyOrderDetailResponse>
JSON
Format
HTTP/1.1 200 OK Content-Type:application/json { "PermApplyOrderDetail" : { "ApplyType" : "DB", "PermType" : 1, "Seconds" : 2592000, "Resources" : [ { "DatabaseInfo" : { "SearchName" : "rds_db@rm-bpxxxxxxxxffxxxxxxi.mysql.rds.aliyuncs.com:3306", "OwnerNickNames" : [ "gctest" ], "DbId" : 1250000, "Logic" : false, "EnvType" : "dev", "DbType" : "mysql", "OwnerIds" : [ 120000 ] }, "ColumnInfo" : { }, "TableInfo" : { }, "InstanceInfo" : { } } ] }, "RequestId" : "806FBC5B-2AED-401C-9E00-0B91C1DB2F1A", "Success" : true }
Error code
Access error Center For more information, see error codes.