Skip to main content

Query Data Source Permissions for an Account

Query the data source permission groups owned by a specified account, including environment lists, data source information, and permission item information.

Request URL: /openapi/v1/permission/accountDatasource/list

Request Method: GET

Request Parameters

ParameterTypeRequiredDescriptionExample
accountIdStringYesAccount ID. You can obtain accountId by calling the List Account Information API.170**********159

Response Parameters

ParameterTypeDescriptionExample
successBooleanWhether the request is successful.true
requestIdStringRequest ID.Mi6y0FCN-BHEEaHAnCFFp9DFdAAk0OUZ
dataArrayList of data source permission groups, including the following fields:
  • groupId: Data source group ID.
  • envList: Environment list.
    • envId: Environment ID.
    • name: Environment name.
  • datasourceList: Data source list.
    • datasourceId: Data source ID.
    • name: Data source name.
  • permissionList: Permission names. Return values:
    • Readonly: Read-only permission.
    • DML: DML permission.
    • DDL: DDL permission.
    • SQLTask: Submit SQL task permission.
    • SQLTaskExecute: Execute SQL task permission.
    • DataGenerate: Submit data generation task permission.
    • DataImport: Submit data import task permission.
    • DataImportExecute: Execute data import task permission.
    • DataExport: Submit data export task permission.
    • DataExportExecute: Execute data export task permission.
    • DataArchive: Data archiving permission.
    • DataTrack: Data tracking permission.
    • Backup: Data backup permission.
    • Restore: Data restoration permission.
    • Replication: Data replication permission.
    • DataCompare: Data comparison permission.
    • SchemaCompare: Schema comparison permission.
    • Management: Data source management permission.
    • DatabaseVersion: Database version management permission.
{
"groupId": "dsg-cryx46pb46b4",
"envList": [{
"envId": "env-product",
"name": "nd.basic.datasource.environment.product"
}],
"datasourceList": [{
"datasourceId": "ds-cryv8xejp3fw",
"name": "sqlserver-2017-aliyun-test"
}],
"permissionList": ["DataImport", "DataImportExecute"]
}

Successful Invocation Example

{
"success": true,
"requestId": "Sy9i9SNG-kqonqYTnspmp3QHdrpp5BZK",
"data": [{
"groupId": "dsg-cryx46pb46b4",
"envList": [{
"envId": "env-product",
"name": "nd.basic.datasource.environment.product"
}],
"datasourceList": [{
"datasourceId": "ds-cryv8xejp3fw",
"name": "sqlserver-2017-aliyun-test"
}],
"permissionList": ["DataImport", "DataImportExecute"]
}]
}