策略授权参考-j9九游会登录
本章节介绍rds策略授权场景下支持的策略授权项。
支持的授权项
策略包含系统策略和自定义策略,如果系统策略不满足授权要求,管理员可以创建自定义策略,并通过给用户组授予自定义策略来进行精细的访问控制。策略支持的操作与api相对应,授权项列表说明如下:
- 权限:允许或拒绝某项操作。
- 对应api接口:自定义策略实际调用的api接口。
- 授权项:自定义策略中支持的action,在自定义策略中的action中写入授权项,可以实现授权项对应的权限功能。
- 依赖的授权项:部分action存在对其他action的依赖,需要将依赖的action同时写入授权项,才能实现对应的权限功能。
- iam项目(project)/企业项目(enterprise project):自定义策略的授权范围,包括iam项目与企业项目。授权范围如果同时支持iam项目和企业项目,表示此授权项对应的自定义策略,可以在iam和企业管理两个服务中给用户组授权并生效。如果仅支持iam项目,不支持企业项目,表示仅能在iam中给用户组授权并生效,如果在企业管理中授权,则该自定义策略不生效。管理员可以在授权项列表中查看授权项是否支持iam项目或企业项目,“√”表示支持,“×”表示暂不支持。关于iam项目与企业项目的区别,详情请参见:iam与企业管理的区别。
rds的支持自定义策略授权项如下所示:
|
权限 |
对应api接口 |
授权项(action) |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
查询数据库引擎版本 |
get /v3/{projectid}/datastores/{database_name} |
rds:instance:listdatabaseversion |
√ |
√ |
|
查询数据库小版本号 |
get /v3/{project_id}/datastores/{database_name}/small-version |
rds:instance:list |
√ |
√ |
|
查询数据库规格 |
get /v3/{project_id}/flavors/{database_name}?version_name={version_name} |
rds:instance:listflavors |
√ |
√ |
|
查询数据库存储规格 |
get /v3/{project_id}/storage-type/{database_name}?version_name={version_name} |
rds:instance:liststoragetype |
√ |
√ |
|
查询版本支持特性(sql server) |
get /v3/{project_id}/major-version-feature |
rds:instance:listall |
√ |
√ |
|
查询云市场服务商列表(sql server) |
get /v3/{project_id}/business-partners |
rds:instance:listall |
√ |
√ |
|
查询云市场引擎商品列表(sql server) |
get /v3/{project_id}/business-partner/{bp_domain_id} |
rds:instance:listall |
√ |
√ |
|
权限 |
对应api接口 |
授权项(action) |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
应用参数模板 |
put /v3.1/{project_id}/configurations/{config_id}/apply |
rds:param:apply |
√ |
√ |
|
修改指定实例的参数 |
put https://{endpoint}/v3.1/{project_id}/instances/{instance_id}/configurations |
rds:param:modify |
√ |
√ |
|
恢复到已有实例或当前实例 |
post /v3.1/{project_id}/instances/recovery |
rds:instance:restoreinplace |
√ |
√ |
|
表级时间点恢复(mysql) |
post /v3.1/{project_id}/instances/{instance_id}/restore/tables |
rds:instance:tablerestore |
√ |
√ |
|
删除数据库(sqlserver) |
delete /v3.1/{project_id}/instances/{instance_id}/database/{db_name} |
rds:database:drop |
√ |
√ |
|
查询慢日志统计信息 |
post /v3.1/{project_id}/instances/{instance_id}/slow-logs/statistics |
rds:log:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项(action) |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
创建数据库实例 |
post /v3/{project_id}/instances |
rds:instance:create (创建加密实例需要在项目上配置kms administrator权限。) |
√ |
√ |
|
停止实例 |
post /v3/{project_id}/instances/{instance_id}/action/shutdown |
rds:instance:operateserver |
√ |
√ |
|
开启实例 |
post /v3/{project_id}/instances/{instance_id}/action/startup |
rds:instance:operateserver |
√ |
√ |
|
修改实例名称 |
put /v3/{project_id}/instances/{instance_id}/name |
rds:instance:modify |
√ |
√ |
|
修改实例备注 |
put /v3/{project_id}/instances/{instance_id}/alias |
rds:instance:modify |
√ |
√ |
|
申请内网域名 |
post /v3/{project_id}/instances/{instance_id}/create-dns |
rds:instance:createdns |
√ |
√ |
|
修改内网域名 |
put /v3/{project_id}/instances/{instance_id}/modify-dns |
rds:instance:modifydns |
√ |
√ |
|
查询实例域名 |
get /v3/{project_id}/instances/{instance_id}/dns |
rds:instance:list |
√ |
√ |
|
查询实例ipv6域名 |
get /v3/{project_id}/instances/{instance_id}/dns-ipv6 |
rds:instance:list |
√ |
√ |
|
获取实例的复制状态 |
get /v3/{project_id}/instances/{instance_id}/replication/status |
rds:instance:list |
√ |
√ |
|
变更数据库实例的规格 |
post /v3/{project_id}/instances/{instance_id}/action |
rds:instance:modifyspec |
√ |
√ |
|
扩容数据库实例的磁盘空间 |
post /v3/{project_id}/instances/{instance_id}/action |
rds:instance:extendspace |
√ |
√ |
|
设置自动扩容策略 |
put /v3/{project_id}/instances/{instance_id}/disk-auto-expansion |
rds:instance:modifydns |
√ |
√ |
|
查询自动扩容策略 |
get /v3/{project_id}/instances/{instance_id}/disk-auto-expansion |
rds:instance:list |
√ |
√ |
|
单机转主备实例 |
post /v3/{project_id}/instances/{instance_id}/action |
rds:instance:singletoha (加密实例需要在项目上配置kms administrator权限。) |
√ |
√ |
|
重启数据库实例 |
post /v3/{project_id}/instances/{instance_id}/action |
rds:instance:restart |
√ |
√ |
|
删除数据库实例 |
delete /v3/{project_id}/instances/{instance_id} |
rds:instance:delete |
√ |
√ |
|
删除实例选择是否保留自动备份(sql server) |
post /v3/{project_id}/instances/{instance_id}/backups/delete-selection |
rds:backup:delete |
√ |
√ |
|
批量删除数据库实例 |
post /v3/{project_id}/instances/batch-delete |
rds:instance:delete |
√ |
√ |
|
查询数据库实例列表 |
get /v3/{project_id}/instances |
rds:instance:list |
√ |
√ |
|
绑定和解绑弹性公网ip |
put /v3/{project_id}/instances/{instance_id}/public-ip |
rds:instance:modifypublicaccess |
√ |
√ |
|
切换主备实例的倒换策略 |
put /v3/{project_id}/instances/{instance_id}/failover/strategy |
rds:instance:modifystrategy |
√ |
√ |
|
手动倒换主备 |
put /v3/{project_id}/instances/{instance_id}/failover |
rds:instance:switchover |
√ |
√ |
|
更改主备实例的数据同步方式 |
put /v3/{project_id}/instances/{instance_id}/failover/mode |
rds:instance:modifysynchronizemodel |
√ |
√ |
|
设置实例读写状态 |
put /v3/{project_id}/instances/{instance_id}/readonly-status |
rds:instance:openreadonly |
√ |
√ |
|
迁移主备实例的备机 |
post /v3/{project_id}/instances/{instance_id}/migrateslave |
rds:instance:create |
√ |
√ |
|
设置可维护时间段 |
put /v3/{project_id}/instances/{instance_id}/ops-window |
rds:instance:modify |
√ |
√ |
|
升级内核小版本 |
post /v3/{project_id}/instances/{instance_id}/db-upgrade |
rds:instance:modify |
√ |
√ |
|
设置秒级监控策略 |
put /v3/{project_id}/instances/{instance_id}/second-level-monitor |
rds:log:switch |
√ |
√ |
|
查询秒级监控策略 |
get /v3/{project_id}/instances/{instance_id}/second-level-monitor |
rds:log:list |
√ |
√ |
|
备机顶替只读节点 |
post /v3/{project_id}/instances/{instance_id}/replace-node |
rds:instance:update |
√ |
√ |
|
查询top sql相关信息 |
get /v3/{project_id}/instances/{instance_id}/top-sqls |
rds:instance:listall |
√ |
√ |
|
查询自动变配策略 |
get /v3/{project_id}/instances/{instance_id}/auto-scaling/policy |
rds:instance:list |
√ |
√ |
|
重建从机 |
put /v3/{project_id}/instances/{instance_id}/rebuild |
rds:instance:modify |
√ |
√ |
|
查询重建从机状态 |
get /v3/{project_id}/instances/{instance_id}/rebuild |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
配置主实例容灾能力 |
post /v3/{project_id}/instances/{instance_id}/action |
rds:instance:builddrrelation |
√ |
√ |
|
配置灾备实例容灾能力 |
post /v3/{project_id}/instances/{instance_id}/action |
rds:instance:builddrrelation |
√ |
√ |
|
灾备升主 |
post /v3/{project_id}/instances/{instance_id}/action |
rds:instance:modifydrrole |
√ |
√ |
|
查询容灾复制状态 |
get /v3/{project_id}/instances/{instance_id}/disaster-recovery |
rds:instance:list |
√ |
√ |
|
批量查询容灾实例信息 |
get /v3/{project_id}/instances/disaster-recovery-relation |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项(action) |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
设置ssl数据加密 |
put /v3/{project_id}/instances/{instance_id}/ssl |
rds:instance:modifyssl |
√ |
√ |
|
获取ssl证书下载地址 |
get /v3/{project_id}/instances/{instance_id}/ssl-cert/download-link |
rds:instance:modifyssl |
√ |
√ |
|
修改数据库端口 |
put /v3/{project_id}/instances/{instance_id}/port |
rds:instance:modifyport |
√ |
√ |
|
修改安全组 |
put /v3/{project_id}/instances/{instance_id}/security-group |
rds:instance:modifysecuritygroup |
√ |
√ |
|
修改内网地址 |
put /v3/{project_id}/instances/{instance_id}/ip |
rds:instance:modifyip |
√ |
√ |
|
弱密码校验 |
post /v3/{project_id}/weakpwd |
rds:password:verify |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
一键kill会话 |
put /v3/{project_id}/instances/{instance_id}/ops/intelligent-kill-session |
rds:instance:modify |
√ |
√ |
|
查询一键kill会话历史 |
get /v3/{project_id}/instances/{instance_id}/ops/intelligent-kill-session/history |
rds:instance:list |
√ |
√ |
|
查询一键kill会话实时统计信息(mysql) |
get /v3/{project_id}/instances/{instance_id}/ops/intelligent-kill-session/statistic |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
设置自动备份策略 |
put /v3/{project_id}/instances/{instance_id}/backups/policy |
rds:instance:modifybackuppolicy |
√ |
√ |
|
设置跨区域备份策略 |
put /v3/{project_id}/instances/{instance_id}/backups/offsite-policy |
rds:instance:modifybackuppolicy |
√ |
√ |
|
查询自动备份策略 |
get /v3/{project_id}/instances/{instance_id}/backups/policy |
rds:instance:list |
√ |
√ |
|
查询跨区域备份策略 |
get https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/backups/offsite-policy |
rds:instance:list |
√ |
√ |
|
创建手动备份 |
post /v3/{project_id}/backups |
rds:backup:create |
√ |
√ |
|
获取备份列表 |
get /v3/{project_id}/backups?instance_id={instance_id}&backup_id={backup_id}&backup_type={backup_type}&offset={offset}&limit={limit}&begin_time={begin _time}&end_time={end_time} |
rds:backup:list |
√ |
√ |
|
查询跨区域备份列表 |
get /v3/{project_id}/offsite-backups?instance_id={instance_id}&backup_id={backup_id}&backup_type={backup_type}&offset={offset}&limit={limit}&begin_time={begin _time}&end_time={end_time} |
rds:backup:list |
√ |
√ |
|
查询跨区域备份实例列表 |
get /v3/backups/offsite-backup-instance?offset={offset}&limit={limit} |
rds:instance:list |
√ |
√ |
|
获取备份下载链接 |
get /v3/{project_id}/backup-files?backup_id={backup_id} |
rds:backup:download |
√ |
√ |
|
删除手动备份 |
delete /v3/{project_id}/backups/{backup_id} |
rds:backup:delete |
√ |
√ |
|
查询可恢复时间段 |
get /v3/{project_id}/instances/{instance_id}/restore-time?date=2020-12-26 |
rds:instance:list |
√ |
√ |
|
查询跨区域备份可恢复时间段 |
get /v3/{project_id}/instances/{instance_id}/offsite-restore-time?date=2020-12-26 |
rds:instance:list |
√ |
√ |
|
恢复到新实例 |
post /v3/{project_id}/instances |
rds:instance:create (加密实例需要在项目上配置kms administrator权限。) |
√ |
√ |
|
查询实例是否能在库表恢复时使用极速恢复(mysql) |
post /v3/{project_id}/instances/fast-restore |
rds:instance:tablerestore |
√ |
√ |
|
查询指定时间点可恢复的库(mysql) |
post /v3/{project_id}/{engine}/instances/history/databases |
rds:backup:list |
√ |
√ |
|
库级时间点恢复(mysql) |
post /v3/{project_id}/instances/batch/restore/databases |
rds:instance:tablerestore |
√ |
√ |
|
查询binlog合并下载文件 |
get /v3/{project_id}/instances/{instance_id}/packlog/infos |
rds:binlog:get |
√ |
√ |
|
查询备份用量总览 |
get /v3/{project_id}/backups/backup-usage |
rds:instance:list |
√ |
√ |
|
查询实例备份概览列表 |
get /v3/{project_id}/instances/backups/summary |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项(action) |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
查询实例可升级的目标版本(postgresql) |
get /v3/{project_id}/instances/{instance_id}/major-version/available-version |
rds:instance:list |
√ |
√ |
|
大版本升级检查(postgresql) |
post /v3/{project_id}/instances/{instance_id}/major-version/inspection |
rds:instance:list |
√ |
√ |
|
查询大版本检查状态或升级状态(postgresql) |
get /v3/{project_id}/instances/{instance_id}/major-version/status?action={current_action} |
rds:instance:list |
√ |
√ |
|
查询实例大版本升级检查历史(postgresql) |
get /v3/{project_id}/instances/{instance_id}/major-version/inspection-histories?offset={offset}&limit={limit}&order={order}&sort_field={sort_field}&target_version={target_version}&is_available={is_available} |
rds:instance:list |
√ |
√ |
|
大版本升级(postgresql) |
post /v3/{project_id}/instances/{instance_id}/major-version/upgrade |
rds:instance:modify |
√ |
√ |
|
查询实例大版本升级历史(postgresql) |
get /v3/{project_id}/instances/{instance_id}/major-version/upgrade-histories?offset={offset}&limit={limit}&order={order}&sort_field={sort_field} |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
查询慢日志 |
post /v3/{project_id}/instances/{instance_id}/slow-logs |
rds:log:list |
√ |
√ |
|
查询错误日志 |
post /v3/{project_id}/instances/{instance_id}/error-logs |
rds:log:list |
√ |
√ |
|
开启和关闭慢日志明文显示 |
put /v3/{project_id}/instances/{instance_id}/slowlog-sensitization/{status} |
rds:log:switch |
√ |
√ |
|
查询慢日志文件列表(sqlserver) |
get /v3/{project_id}/instances/{instance_id}/slowlog-files |
rds:log:list |
√ |
√ |
|
查询扩展日志(sqlserver) |
get /v3/{project_id}/instances/{instance_id}/xellog-files |
rds:log:list |
√ |
√ |
|
生成扩展日志链接(sqlserver) |
post /v3/{project_id}/instances/{instance_id}/xellog-download |
rds:log:download |
√ |
√ |
|
获取慢日志下载链接 |
post /v3/{project_id}/instances/{instance_id}/slowlog-download |
rds:log:download |
√ |
√ |
|
设置审计日志策略 |
put /v3/{project_id}/instances/{instance_id}/auditlog-policy |
rds:auditlog:operate |
√ |
√ |
|
查询审计日志策略 |
get /v3/{project_id}/instances/{instance_id}/auditlog-policy |
rds:auditlog:list |
√ |
√ |
|
获取审计日志列表 |
get /v3/{project_id}/instances/{instance_id}/auditlog?start_time={start_time}&end_time={end_time}&offset={offset}&limit={limit} |
rds:auditlog:list |
√ |
√ |
|
生成审计日志下载链接 |
post /v3/{project_id}/instances/{instance_id}/auditlog-links |
rds:auditlog:download |
√ |
√ |
|
设置binlog本地保留时长 |
put /v3/{project_id}/instances/{instance_id}/binlog/clear-policy |
rds:binlog:setpolicy |
√ |
√ |
|
获取binlog本地保留时长 |
get /v3/{project_id}/instances/{instance_id}/binlog/clear-policy |
rds:binlog:get |
√ |
√ |
|
查询lts配置列表 |
get /v3/{project_id}/{engine}/instances/logs/lts-configs |
rds:instance:listall |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
查询当前用户自动告警配置 |
get /v3/{project_id}/auto-ces-alarm |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
获取诊断后的实例数 |
get /v3/{project_id}/instances/diagnosis |
rds:instance:list |
√ |
√ |
|
获取指定诊断项的诊断结果 |
get /v3/{project_id}/instances/diagnosis/info |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
开启数据库代理 |
post /v3/{project_id}/instances/{instance_id}/proxy/open |
rds:instance:modifyproxy |
√ |
√ |
|
查询数据库代理信息列表 |
get /v3/{project_id}/instances/{instance_id}/proxy-list |
rds:instance:list |
√ |
√ |
|
查询数据库代理规格信息 |
get /v3/{project_id}/instances/{instance_id}/proxy/flavors |
rds:instance:list |
√ |
√ |
|
关闭数据库代理 |
delete /v3/{project_id}/instances/{instance_id}/proxy/{proxy_id} |
rds:instance:modifyproxy |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
创建数据库 |
post /v3/{project_id}/instances/{instance_id}/database |
rds:database:create |
√ |
√ |
|
查询数据库列表 |
get /v3/{project_id}/instances/{instance_id}/database/detail?page={page}&limit={limit} |
rds:database:list |
√ |
√ |
|
修改指定实例的数据库备注 |
post /v3/{project_id}/instances/{instance_id}/database/update |
rds:database:create |
√ |
√ |
|
删除数据库 |
delete /v3/{project_id}/instances/{instance_id}/database/{db_name} |
rds:database:drop |
√ |
√ |
|
创建数据库用户 |
post /v3/{project_id}/instances/{instance_id}/db_user |
rds:databaseuser:create |
√ |
√ |
|
查询数据库用户列表 |
get /v3/{project_id}/instances/{instance_id}/db_user/detail?page={page}&limit={limit} |
rds:databaseuser:list |
√ |
√ |
|
查询指定数据库的已授权用户 |
get /v3/{project_id}/instances/{instance_id}/database/db_user?db-name={db-name}&page={page}&limit={limit} |
rds:databaseuser:list |
√ |
√ |
|
修改数据库用户的备注 |
put /v3/{project_id}/instances/{instance_id}/db-users/{user_name}/comment |
rds:databaseuser:update |
√ |
√ |
|
删除数据库用户 |
delete /v3/{project_id}/instances/{instance_id}/db_user/{user_name} |
rds:databaseuser:drop |
√ |
√ |
|
设置数据库账号密码 |
post /v3/{project_id}/instances/{instance_id}/db_user/resetpwd |
rds:password:update |
√ |
√ |
|
授权数据库账号 |
post /v3/{project_id}/instances/{instance_id}/db_privilege |
rds:databaseprivilege:grant |
√ |
√ |
|
解除数据库账号权限 |
delete /v3/{project_id}/instances/{instance_id}/db_privilege |
rds:databaseprivilege:revoke |
√ |
√ |
|
重置数据库root账号密码 |
post /v3/{project_id}/instances/{instance_id}/password |
rds:password:update |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
创建数据库 |
post /v3/{project_id}/instances/{instance_id}/database |
rds:database:create |
√ |
√ |
|
创建数据库用户 |
post /v3/{project_id}/instances/{instance_id}/db_user |
rds:databaseuser:create |
√ |
√ |
|
创建数据库schema |
post /v3/{project_id}/instances/{instance_id}/schema |
rds:database:create |
√ |
√ |
|
授权数据库账号的读写权限 |
post /v3/{project_id}/instances/{instance_id}/db_privilege |
rds:databaseprivilege:grant |
√ |
√ |
|
授权数据库账号的操作权限 |
post /v3/{project_id}/instances/{instance_id}/db-user-privilege |
rds:databaseprivilege:grant |
√ |
√ |
|
重置数据库账号密码 |
post /v3/{project_id}/instances/{instance_id}/db_user/resetpwd |
rds:password:update |
√ |
√ |
|
查询数据库列表 |
get /v3/{project_id}/instances/{instance_id}/database/detail?page={page}&limit={limit} |
rds:database:list |
√ |
√ |
|
查询数据库用户列表 |
get /v3/{project_id}/instances/{instance_id}/db_user/detail?page={page}&limit={limit} |
rds:databaseuser:list |
√ |
√ |
|
查询数据库schema列表 |
get /v3/{project_id}/instances/{instance_id}/schema/detail?db_name={name}&page={page}&limit={limit} |
rds:database:list |
√ |
√ |
|
设置数据库用户权限 |
post /v3/{project_id}/instances/{instance_id}/user-privilege |
rds:databaseprivilege:grant |
√ |
√ |
|
修改指定实例的数据库备注 |
post /v3/{project_id}/instances/{instance_id}/database/update |
rds:database:create |
√ |
√ |
|
修改数据库用户的备注 |
put /v3/{project_id}/instances/{instance_id}/db-users/{user_name}/comment |
rds:databaseuser:update |
√ |
√ |
|
删除数据库 |
delete /v3/{project_id}/instances/{instance_id}/database/{db_name} |
rds:database:drop |
√ |
√ |
|
删除数据库用户 |
delete /v3/{project_id}/instances/{instance_id}/db_user/{user_name} |
rds:databaseuser:drop |
√ |
√ |
|
查询实例的pg_hba.conf文件配置 |
get /v3/{project_id}/instances/{instance_id}/hba-info |
rds:databaseuser:list |
√ |
√ |
|
修改pg_hba.conf文件的单个或多个配置 |
put /v3/{project_id}/instances/{instance_id}/hba-info |
rds:databaseuser:update |
√ |
√ |
|
覆盖当前pg_hba.conf文件的配置 |
post /v3/{project_id}/instances/{instance_id}/hba-info |
rds:databaseuser:create |
√ |
√ |
|
删除pg_hba.conf文件的单个或多个配置 |
delete /v3/{project_id}/instances/{instance_id}/hba-info |
rds:databaseuser:drop |
√ |
√ |
|
查询实例的pg_hba.conf文件修改历史 |
get /v3/{project_id}/instances/{instance_id}/hba-info/history |
rds:databaseuser:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
查询sql server可用字符集 |
get /v3/{project_id}/collations |
rds:database:list |
√ |
√ |
|
创建数据库 |
post /v3/{project_id}/instances/{instance_id}/database |
rds:database:create |
√ |
√ |
|
查询数据库列表 |
get /v3/{project_id}/instances/{instance_id}/database/detail?page={page}&limit={limit}&db-name={db-name}&recover_model={recover_model} |
rds:database:list |
√ |
√ |
|
创建数据库用户 |
post /v3/{project_id}/instances/{instance_id}/db_user |
rds:databaseuser:create |
√ |
√ |
|
设置数据库账号密码 |
post /v3/{project_id}/instances/{instance_id}/db_user/resetpwd |
rds:password:update |
√ |
√ |
|
查询数据库用户列表 |
get /v3/{project_id}/instances/{instance_id}/db_user/detail?page={page}&limit={limit} |
rds:databaseuser:list |
√ |
√ |
|
查询指定数据库的已授权用户 |
get /v3/{project_id}/instances/{instance_id}/database/db_user?db-name={db-name}&page={page}&limit={limit} |
rds:databaseuser:list |
√ |
√ |
|
删除数据库用户 |
delete /v3/{project_id}/instances/{instance_id}/db_user/{user_name} |
rds:databaseuser:drop |
√ |
√ |
|
授权数据库账号 |
post /v3/{project_id}/instances/{instance_id}/db_privilege |
rds:databaseprivilege:grant |
√ |
√ |
|
解除数据库账号权限 |
delete /v3/{project_id}/instances/{instance_id}/db_privilege |
rds:databaseprivilege:revoke |
√ |
√ |
|
添加msdtc |
post /v3/{project_id}/instances/{instance_id}/msdtc/host |
rds:instance:modify |
√ |
√ |
|
查询msdtc的hosts信息 |
get /v3/{project_id}/instances/{instance_id}/msdtc/hosts?offset={offset}&limit={limit} |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
获取参数模板列表 |
get /v3/{project_id}/configurations |
rds:param:list |
√ |
√ |
|
创建参数模板 |
post /v3/{project_id}/configurations |
rds:param:create |
√ |
√ |
|
修改参数模板参数 |
put /v3/{project_id}/configurations/{config_id} |
rds:param:modify |
√ |
√ |
|
复制参数模板 |
post /v3/{project_id}/configurations/{config_id}/copy |
rds:param:create |
√ |
√ |
|
查询实例参数修改历史 |
get /v3/{project_id}/instances/{instance_id}/configuration-histories?offset={offset}&limit={limit}&start_time={start_time}&end_time={end_time}¶m_name={param_name} |
rds:param:list |
√ |
√ |
|
获取指定实例的参数模板 |
get /v3/{project_id}/instances/{instance_id}/configurations |
rds:param:list |
√ |
√ |
|
获取指定参数模板的参数 |
get /v3/{project_id}/configurations/{config_id} |
rds:param:list |
√ |
√ |
|
删除参数模板 |
delete /v3/{project_id}/configurations/{config_id} |
rds:param:delete |
√ |
√ |
|
应用参数模板 |
put /v3/{project_id}/configurations/{config_id}/apply |
rds:param:apply |
√ |
√ |
|
查询参数模板应用历史 |
get /v3/{project_id}/configurations/{config_id}/apply-histories |
rds:param:list |
√ |
√ |
|
查询应用参数模板的实例列表 |
get /v3/{project_id}/configurations/{config_id}/query-instances |
rds:instance:list |
√ |
√ |
|
修改指定实例的参数 |
put /v3/{project_id}/instances/{instance_id}/configurations |
rds:param:modify |
√ |
√ |
|
比较参数模板 |
put /v3/{project_id}/configurations/difference |
rds:param:list |
√ |
√ |
|
重置自定义参数模板 |
put /v3/{project_id}/configurations/{config_id}/reset |
rds:param:reset |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
创建插件 |
post /v3/{project_id}/instances/{instance_id}/extensions |
rds:database:create |
√ |
√ |
|
查询插件 |
get /v3/{project_id}/instances/{instance_id}/extensions?database_name={database_name}&offset={offset}&limit={limit} |
rds:database:list |
√ |
√ |
|
删除插件 |
delete /v3/{project_id}/instances/{instance_id}/extensions |
rds:database:drop |
√ |
√ |
|
修改实例指定参数的值 |
put /v3/{project_id}/instances/{instance_id}/parameter/{name} |
rds:param:modify |
√ |
√ |
|
获取实例指定参数的值 |
get /v3/{project_id}/instances/{instance_id}/parameter/{name} |
rds:param:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
查询订阅服务器实例列表 |
get /v3/{project_id}/instances/{instance_id}/replication/subscribers |
rds:instance:modify |
√ |
√ |
|
创建订阅 |
post /v3/{project_id}/instances/{instance_id}/replication/subscriptions |
rds:instance:modify |
√ |
√ |
|
查询实例发布信息 |
get /v3/{project_id}/instances/{instance_id}/replication/publications |
rds:instance:modify |
√ |
√ |
|
删除发布 |
delete /v3/{project_id}/instances/{instance_id}/replication/publications |
rds:instance:modify |
√ |
√ |
|
查询分发服务器 |
get /v3/{project_id}/instances/{instance_id}/replication/distribution |
rds:instance:modify |
√ |
√ |
|
修改发布 |
put /v3/{project_id}/instances/{instance_id}/replication/publications/{publication_id} |
rds:instance:modify |
√ |
√ |
|
查询分发服务器实例列表 |
get /v3/{project_id}/instances/{instance_id}/replication/distributors |
rds:instance:modify |
√ |
√ |
|
删除订阅 |
delete /v3/{project_id}/instances/{instance_id}/replication/subscriptions |
rds:instance:modify |
√ |
√ |
|
删除分发服务器 |
delete /v3/{project_id}/instances/{instance_id}/replication/distribution |
rds:instance:modify |
√ |
√ |
|
查询发布监控信息 |
get /v3/{project_id}/instances/{instance_id}/replication/publications/{publication_id}/monitor |
rds:instance:modify |
√ |
√ |
|
查询订阅监控信息 |
get /v3/{project_id}/instances/{instance_id}/replication/subscriptions/{subscription_id}/monitor |
rds:instance:modify |
√ |
√ |
|
登录测试 |
post /v3/{project_id}/instances/{instance_id}/replication/login-test |
rds:instance:modify |
√ |
√ |
|
查询实例订阅信息 |
get /v3/{project_id}/instances/{instance_id}/replication/subscriptions?offset={offset}&limit={limit}&publication_id={publication_id}&is_cloud={is_cloud}&publication_name={publication_name}&subscription_db_name={subscription_db_name} |
rds:instance:modify |
√ |
√ |
|
查询发布订阅配置文件列表 |
get /v3/{project_id}/instances/{instance_id}/replication/profiles?offset={offset}&limit={limit}&agent_type={agent_type} |
rds:instance:modify |
√ |
√ |
|
批量修改订阅 |
put /v3/{project_id}/instances/{instance_id}/replication/subscriptions |
rds:instance:modify |
√ |
√ |
|
查询实例可选发布 |
post /v3/{project_id}/instances/{instance_id}/replication/publication-candidates |
rds:instance:modify |
√ |
√ |
|
查询数据库代理作业列表 |
get /v3/{project_id}/instances/{instance_id}/db-jobs?offset={offset}&limit={limit}&job_type={job_type} |
rds:instance:modify |
√ |
√ |
|
查询数据库代理作业执行历史 |
get /v3/{project_id}/instances/{instance_id}/db-jobs/{job_id}/histories?offset={offset}&limit={limit}&run_status={run_status} |
rds:instance:modify |
√ |
√ |
|
重新生成发布快照 |
post /v3/{project_id}/instances/{instance_id}/replication/publications/{publication_id}/reinitialize |
rds:instance:modify |
√ |
√ |
|
重新生成订阅 |
post /v3/{project_id}/instances/{instance_id}/replication/subscriptions/{subscription_id}/reinitialize |
rds:instance:modify |
√ |
√ |
|
同步发布订阅元数据 |
post /v3/{project_id}/instances/{instance_id}/replication/metadata/sync |
rds:instance:modify |
√ |
√ |
|
查询数据库代理作业执行历史步骤 |
get /v3/{project_id}/instances/{instance_id}/db-jobs/histories/{history_id}/steps?offset={offset}&limit={limit} |
rds:instance:modify |
√ |
√ |
|
修改数据库代理作业 |
put /v3/{project_id}/instances/{instance_id}/db-jobs/{job_id} |
rds:instance:modify |
√ |
√ |
|
重启数据库代理作业 |
post /v3/{project_id}/instances/{instance_id}/db-jobs/{job_id}/restart |
rds:instance:modify |
√ |
√ |
|
禁用启动切换数据库代理作业 |
post /v3/{project_id}/instances/{instance_id}/db-jobs/{job_id}/switch |
rds:instance:modify |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
设置回收站策略 |
put /v3/{project_id}/instances/recycle-policy |
rds:instance:setrecyclebin |
√ |
√ |
|
查询回收站策略 |
get /v3/{project_id}/instances/recycle-policy |
rds:instance:list |
√ |
√ |
|
查询回收站实例信息 |
get /v3/{project_id}/recycle-instances?offset={offset}&limit={limit} |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
批量添加标签 |
post /v3/{project_id}/instances/{instance_id}/tags/action |
rds:instance:dealtag |
√ |
√ |
|
批量删除标签 |
post /v3/{project_id}/instances/{instance_id}/tags/action |
rds:instance:dealtag |
√ |
√ |
|
查询项目标签 |
get /v3/{project_id}/tags |
rds:tag:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
查询配额 |
get /v3/{project_id}/quotas |
rds:instance:list |
√ |
√ |
|
api功能 |
对应api接口 |
授权项 |
iam项目(project) |
企业项目(enterprise project) |
|---|---|---|---|---|
|
查询定时任务列表 |
get /v3/{project_id}/schedule-tasks |
rds:task:listall |
√ |
√ |
|
查询即时任务列表 |
get /v3/{project_id}/tasklist |
rds:task:listall |
√ |
√ |
|
获取指定id的任务信息 |
get /v3/{project_id}/jobs?id={id} |
rds:task:list |
√ |
√ |
|
获取指定实例和时间范围的任务信息(sqlserver) |
get /v3/{project_id}/instances/{instance_id}/tasklist/detail?start_time={start_time}&end_time={end_time} |
rds:task:list |
√ |
√ |
|
删除即时任务 |
delete /v3/{project_id}/jobs |
rds:task:delete |
√ |
√ |
相关文档
意见反馈
文档内容是否对您有帮助?
如您有其它疑问,您也可以通过华为云社区问答频道来与我们联系探讨