全部文档
当前文档

暂无内容

如果没有找到您期望的内容,请尝试其他搜索词

文档中心

获取当前实例数据库列表

最近更新时间:2021-11-08 17:48:18

DescribeInstanceDatabases 获取当前实例数据库列表

获取当前实例的数据库列表。

请求方式

GET

请求参数

英文名称 中文名称 类型 是否必须 备注
Action 调用接口名称 String 取固定值:DescribeInstanceDatabases
Version API版本号 String 取固定值:2016-07-01
DBInstanceIdentifier 实例Id String 实例id
InstanceDatabaseName 数据库名称准确查询 String
Keyword 数据库名称模糊查询 String

返回值

英文名称 中文名称 类型 备注
RequestId 请求ID String
Data.InstanceDatabases 数据库列表 List

Data.InstanceDatabases:

英文名称 中文名称 类型 备注
InstanceDatabaseName 数据库名称 String
InstanceDatabaseCollation 数据库字符集 String
InstanceDatabaseCollationSet 数据库字符集 String
InstanceDatabaseStatus 数据库状态:CREATING, ACTIVE, TASKS String
InstanceDatabaseDescription 数据库描述 String 创建时添加了描述才会返回
InstanceDatabasePrivileges 数据库权限(权限拥有者及对应权限) List

InstanceDatabasePrivileges:

英文名称 中文名称 类型 备注
InstanceAccountName 数据库账户名称 String
Privilege 数据库账户权限 String 只读:ReadOnly,
读写:ReadWrite,
仅DDL:DDLOnly,
仅DML:DMLOnly,

请求示例

http://krds.{{region}}.api.ksyun.com/?Action=DescribeInstanceDatabases&Version=2016-07-01&DBInstanceIdentifier=4d97f65f-5603-4373-b870-48a280ecc464

示例返回

{
    "Data": {
        "InstanceDatabases": [
            {
                "InstanceDatabaseName": "kingsoft_001",
                "InstanceDatabaseCollation": "utf8_general_ci",
                "InstanceDatabaseCollationSet": "utf8",
                "InstanceDatabaseDescription": "kingsoft_001_未同时授权",
                "InstanceDatabaseStatus": "ACTIVE",
                "InstanceDatabasePrivileges": []
            },
            {
                "InstanceDatabaseName": "kingsoft_002",
                "InstanceDatabaseCollation": "utf8_general_ci",
                "InstanceDatabaseCollationSet": "utf8",
                "InstanceDatabaseDescription": "kingsoft_002_同时授权_只读",
                "InstanceDatabaseStatus": "ACTIVE",
                "InstanceDatabasePrivileges": [
                    {
                        "InstanceAccountName": "w_liangliang",
                        "Privilege": "ReadOnly"
                    }
                ]
            },
            {
                "InstanceDatabaseName": "kingsoft_003",
                "InstanceDatabaseCollation": "utf8_general_ci",
                "InstanceDatabaseCollationSet": "utf8",
                "InstanceDatabaseDescription": "kingsoft_003_读写",
                "InstanceDatabaseStatus": "ACTIVE",
                "InstanceDatabasePrivileges": [
                    {
                        "InstanceAccountName": "w_liangliang",
                        "Privilege": "ReadWrite"
                    }
                ]
            },
            {
                "InstanceDatabaseName": "kingsoft_004",
                "InstanceDatabaseCollation": "utf8_general_ci",
                "InstanceDatabaseCollationSet": "utf8",
                "InstanceDatabaseDescription": "kingsoft_004_授权_仅DDL",
                "InstanceDatabaseStatus": "ACTIVE",
                "InstanceDatabasePrivileges": [
                    {
                        "InstanceAccountName": "w_liangliang",
                        "Privilege": "DDLOnly"
                    }
                ]
            },
            {
                "InstanceDatabaseName": "kingsoft_005",
                "InstanceDatabaseCollation": "utf8_general_ci",
                "InstanceDatabaseCollationSet": "utf8",
                "InstanceDatabaseDescription": "kingsoft_005_授权_仅DML",
                "InstanceDatabaseStatus": "ACTIVE",
                "InstanceDatabasePrivileges": [
                    {
                        "InstanceAccountName": "w_liangliang",
                        "Privilege": "DMLOnly"
                    }
                ]
            }
        ]
    },
    "RequestId": "750d36b8-7d7e-434d-b130-cc97c4abf73b"
}
文档导读
纯净模式常规模式

纯净模式

点击可全屏预览文档内容
文档反馈