Description
You can call this API to retrieve information about all accounts of a specific instance.
Note The required parameters in this operation contain private data such as passwords. For your data security, you must call this operation over HTTPS.
Request parameters
Name | Type | Required | Description |
---|---|---|---|
<Common request parameters> | - | - | For more information, see Common parameters. |
Action | String | Yes | Required parameter, and the value is DescribeAccounts. |
InstanceId | String | Yes | The ID of the instance, which is unique in Alibaba Cloud. |
Response parameters
Name | Type | Required |
---|---|---|
<Common response parameters> | String | For more information, see Common response parameters. |
AccountList | List<Account> | The list of accounts. |
Name | Type | Description |
---|---|---|
AccountName | String | The name of the account. |
AccountStatus | String | The status of the account.
|
AccountDescription | String | The remarks for the account. |
AccountType | String | The type of the account.
|
DatabasePrivileges | List<DatabasePrivilege> | The account privileges on a database. |
Name | Type | Description |
---|---|---|
DBName | String | The name of the database. |
AccountPrivilege | String | The account privilege on the database.
|
AccountPrivilegeDetail | String | The specific privileges that the account is granted on the database, such as SELECT, UPDATE, and ALTER. This parameter only returns the privileges granted by the super user with Grant statement, not the privileges granted on HybridDB for MySQL console. |
Sample requests
https://petadata.aliyuncs.com/?Action=DescribeAccounts
&InstanceId=pd-xxxxxxxxxxxxxx
&<[Common request parameters]>
Sample responses
XML format
<DescribeAccountsResponse>
<RequestId>43478987-E313-472E-8C45-9DFD81871198</RequestId>
<AccountList>
<Account>
<DatabasePrivileges>
<DatabasePrivilege>
<AccountPrivilege>ReadWrite</AccountPrivilege>
<AccountPrivilegeDetail>SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE,EXECUTE,EVENT,TRIGGER</AccountPrivilegeDetail>
<DBName>adb</DBName>
</DatabasePrivilege>
</DatabasePrivileges>
<AccountStatus>ACTIVE</AccountStatus>
<AccountDescription></AccountDescription>
<AccountName>testac01</AccountName>
<AccountType>Normal</AccountType>
</Account>
<Account>
<DatabasePrivileges>
<DatabasePrivilege>
<AccountPrivilege>DDLOnly</AccountPrivilege>
<AccountPrivilegeDetail>CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE</AccountPrivilegeDetail>
<DBName>test</DBName>
</DatabasePrivilege>
</DatabasePrivileges>
<AccountStatus>ACTIVE</AccountStatus>
<AccountDescription></AccountDescription>
<AccountName>testac02</AccountName>
<AccountType>Normal</AccountType>
</Account>
<Account>
<DatabasePrivileges>
<DatabasePrivilege>
<AccountPrivilege></AccountPrivilege>
<AccountPrivilegeDetail></AccountPrivilegeDetail>
</DatabasePrivilege>
</DatabasePrivileges>
<AccountStatus>ACTIVE</AccountStatus>
<AccountDescription></AccountDescription>
<AccountName>testac03</AccountName>
<AccountType>Normal</AccountType>
</Account>
<Account>
<DatabasePrivileges>
<DatabasePrivilege>
<AccountPrivilege>ReadWrite</AccountPrivilege>
<AccountPrivilegeDetail>SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE,EXECUTE,EVENT,TRIGGER</AccountPrivilegeDetail>
<DBName>adb</DBName>
</DatabasePrivilege>
</DatabasePrivileges>
<AccountStatus>ACTIVE</AccountStatus>
<AccountDescription></AccountDescription>
<AccountName>testac04</AccountName>
<AccountType>Normal</AccountType>
</Account>
<Account>
<DatabasePrivileges>
<DatabasePrivilege>
<AccountPrivilege></AccountPrivilege>
<AccountPrivilegeDetail></AccountPrivilegeDetail>
</DatabasePrivilege>
</DatabasePrivileges>
<AccountStatus>ACTIVE</AccountStatus>
<AccountDescription></AccountDescription>
<AccountName>testac05</AccountName>
<AccountType>Normal</AccountType>
</Account>
</AccountList>
</DescribeAccountsResponse>
JSON format
{
"RequestId":"43478987-E313-472E-8C45-9DFD81871198",
"AccountList":{
"Account": [
{
"DatabasePrivileges":{
"DatabasePrivilege":[
{
"AccountPrivilege":"ReadWrite",
"AccountPrivilegeDetail":"SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE,EXECUTE,EVENT,TRIGGER",
"DBName":"adb"
}
]
},
"AccountStatus":"ACTIVE",
"AccountDescription":"",
"AccountName":"testac01",
"AccountType":"Normal"
},
{
"DatabasePrivileges":{
"DatabasePrivilege":[
{
"AccountPrivilege":"DDLOnly",
"AccountPrivilegeDetail":"CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE",
"DBName":"adb"
}
]
},
"AccountStatus":"ACTIVE",
"AccountDescription":"",
"AccountName":"testac02",
"AccountType":"Normal"
},
{
"DatabasePrivileges":{
"DatabasePrivilege":[
{
"AccountPrivilege":"",
"AccountPrivilegeDetail":""
}
]
},
"AccountStatus":"ACTIVE",
"AccountDescription":"",
"AccountName":"testac03",
"AccountType":"Normal"
},
{
"DatabasePrivileges":{
"DatabasePrivilege":[
{
"AccountPrivilege":"ReadWrite",
"AccountPrivilegeDetail":"SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE,EXECUTE,EVENT,TRIGGER",
"DBName":"adb"
}
]
},
"AccountStatus":"ACTIVE",
"AccountDescription":"",
"AccountName":"testac04",
"AccountType":"Normal"
},
{
"DatabasePrivileges":{
"DatabasePrivilege":[
{
"AccountPrivilege":"",
"AccountPrivilegeDetail":""
}
]
},
"AccountStatus":"ACTIVE",
"AccountDescription":"",
"AccountName":"testac05",
"AccountType":"Normal"
}
]
}
}