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

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

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:

  • true : Yes
  • false : no
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:

  • 1 : Query
  • 2 : Export
  • 3 : Query + export
  • 4 : Change
  • 5 : Query + change
  • 6 : Export + change
  • 7 : Query + export + change
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:

  • DB : Library permission
  • TAB : table permission
  • COL : column permission
  • INSTANT : instance permission

Examples

Sample requests


     http(s)://dms-enterprise.aliyuncs.com/? srderlimit D=73000&regionid=-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.