1.接口描述

Action：DescribeDbPrivileges

描述： 获取云数据库MySQL普通用户详细权限

请求地址：cdsapi.capitalonline.net/mysql

请求方法： GET

2.请求参数

无

3.请求示例

def get_mysql_user_privileges():
    """
    获取云数据库MySQL普通用户详细权限
    """
    action = "DescribeDbPrivileges"
    method = "GET"
    param = {
    }
    url = get_signature(action, AK, AccessKeySecret, method, MYSQL_URL, param)
    res = requests.get(url)
    result = json.loads(res.content)
    result = json.dumps(result)  # json格式化
    print(result)

4.返回参数

参数名	类型	说明
Code	string	状态码
Data	DataObj	MySQL普通用户权限明细数据集合
Message	string	返回调用接口状态信息和code相对应，比如：Success, Error

DataObj

参数名	类型	说明
ReadWrite	string	读写权限详细权限说明
DMLOnly	string	仅DML权限详细权限说明
ReadOnly	string	只读权限详细权限说明
DDLOnly	string	仅DDL权限详细权限说明

5.返回示例

{
    "Code": "Success",
    "Data": {
        "DDLOnly": "CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE",
        "DMLOnly": "SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, SHOW VIEW, EVENT, TRIGGER",
        "ReadOnly": "SELECT, LOCK TABLES, SHOW VIEW",
        "ReadWrite": "SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER"
    },
    "Message": "success"
}