DAS授权分类
API功能 |
对应API接口 |
授权项(Action) |
IAM项目(Project) |
企业项目(Enterprise Project) |
---|---|---|---|---|
查询API版本列表 |
GET /das |
无需授权 |
√ |
√ |
查询API版本信息 |
GET /das/{version} |
无需授权 |
√ |
√ |
注册数据库用户 |
POST /v3/{project_id}/instances/{instance_id}/db-users |
das:*:* |
√ |
√ |
查询数据库用户列表 |
GET /v3/{project_id}/instances/{instance_id}/db-users |
das:*:* |
√ |
√ |
查询数据库用户信息 |
GET /v3/{project_id}/instances/{instance_id}/db-users/{db_user_id} |
das:*:* |
√ |
√ |
修改数据库用户 |
PUT /v3/{project_id}/instances/{instance_id}/db-users/{db_user_id} |
das:*:* |
√ |
√ |
删除数据库用户 |
DELETE /v3/{project_id}/instances/{instance_id}/db-users/{db_user_id} |
das:*:* |
√ |
√ |
查询SQL执行计划 |
GET /v3/{project_id}/instances/{instance_id}/sql/explain |
das:*:* |
√ |
√ |
查询实例会话列表 |
GET /v3/{project_id}/instances/{instance_id}/processes |
das:*:* |
√ |
√ |
查杀会话 |
DELETE /v3/{project_id}/instances/{instance_id}/process |
das:*:* |
√ |
√ |
查询元数据锁列表 |
GET /v3/{project_id}/instances/{instance_id}/metadata-locks |
das:*:* |
√ |
√ |
查询InnoDB锁等待列表 |
GET /v3/{project_id}/instances/{instance_id}/innodb-locks |
das:*:* |
√ |
√ |
获取空间分析数据列表 |
GET /v3/{project_id}/instances/{instance_id}/space-analysis |
das:*:* |
√ |
√ |
创建空间分析任务 |
POST /v3/{project_id}/instances/{instance_id}/space-analysis |
das:*:* |
√ |
√ |
开启/关闭全量SQL和慢SQL开关 |
POST /v3/{project_id}/instances/{instance_id}/sql/switch |
das:*:* |
√ |
√ |
查询全量SQL和慢SQL的开关状态 |
GET /v3/{project_id}/instances/{instance_id}/sql/switch |
das:*:* |
√ |
√ |
导出慢SQL数据 |
GET /v3/{project_id}/instances/{instance_id}/slow-query-logs |
das:*:* |
√ |
√ |
导出全量SQL数据 |
GET /v3/{project_id}/instances/{instance_id}/sql-statements |
das:*:* |
√ |
√ |
查看SQL限流开关状态 |
GET /v3/{project_id}/instances/{instance_id}/sql-limit/switch |
das:*:* |
√ |
√ |
设置SQL限流开关状态 |
POST /v3/{project_id}/instances/{instance_id}/sql-limit/switch |
rds:databasePrivilege:grant |
√ |
√ |
查询SQL限流规则列表 |
GET /v3/{project_id}/instances/{instance_id}/sql-limit/rules |
das:*:* |
√ |
√ |
创建SQL限流规则 |
POST /v3/{project_id}/instances/{instance_id}/sql-limit/rules |
rds:databasePrivilege:grant |
√ |
√ |
删除SQL限流规则 |
DELETE /v3/{project_id}/instances/{instance_id}/sql-limit/rules |
rds:databasePrivilege:grant |
√ |
√ |
查询SQL限流任务 |
GET /v3/{project_id}/instances/{instance_id}/sql-limit/job |
das:*:* |
√ |
√ |
导出TopSQL模板列表 |
GET /v3/{project_id}/instances/{instance_id}/top-sql-templates |
das:*:* |
√ |
√ |
导出SQL执行耗时区间数据 |
GET /v3/{project_id}/instances/{instance_id}/top-sql-trend |
das:*:* |
√ |
√ |
导出慢SQL模板列表 |
GET /v3/{project_id}/instances/{instance_id}/slow-sql-templates |
das:*:* |
√ |
√ |
设置共享链接 |
POST /v3/{project_id}/connections/share |
das:*:* |
√ |
√ |
删除共享链接 |
DELETE /v3/{project_id}/connections/share |
das:*:* |
√ |
√ |
执行SQL诊断 |
POST /v3/{project_id}/connections/{connection_id}/tuning/create-tuning |
das:*:* |
√ |
√ |
获取诊断结果 |
GET /v3/{project_id}/connections/{connection_id}/tuning/{message_id}/show-tuning-result |
das:*:* |
√ |
√ |
- “√”表示支持,“x”表示暂不支持。
- 部分接口暂未设置授权项,请添加das:*:* 授权项,或直接添加DAS FullAccess系统策略调用接口。