You need to enable JavaScript to run this app.
RDS for MySQL

RDS for MySQL

  • Documentation
    • RDS for MySQLAPI referenceV2（2022-01-01）Managing accountsDescribeDBAccountTableColumnInfo
Copy page
Download PDF
Managing accounts
DescribeDBAccountTableColumnInfo
Copy page
Download PDF
DescribeDBAccountTableColumnInfo

Call the RevokeDBAccountPrivilege API to revoke permissions from a database account.

Request type

Synchronous request.

Request parameters

Name
Type
Required
Example
Description
InstanceId
String
Yes
mysql-d6ce108d****
Instance ID.
DBName
String
Yes
db1
Database name.
AccountName
String
No
user1

Account name.

tip

When the account name is not specified, all permission information will return null.

Host
String
No
%
Specify the IP address from which the account accesses the database. The default value is %.
TableName
String
No
table1
Search for table column permission settings in the database by table name.
ColumnName
String
No
column1
Search for table column permission settings in the database by column name.
TableLimit
Integer
No
5
Specify the number of table column permission entries to return. Results exceeding this limit will be truncated.

Response parameters

Name
Type
Example
Description
TableInfos
Object[]
Please refer to the response example.
Table column permission information of the specified database in the instance.
AccountPrivileges
String[]
[ "SELECT", "INSERT", "REFERENCES", "CREATE VIEW", "TRIGGER" ]

The table-level permission information the account has in this table. Valid values (multiple options allowed):

  • ALTER
  • CREATE
  • DELETE
  • DROP
  • INDEX
  • INSERT
  • SELECT
  • SHOW VIEW
  • TRIGGER
  • UPDATE
  • CREATE VIEW
  • REFERENCES
ColumnInfos
Object[]
Please refer to the response example.
The column-level permission information the account has in this table.
AccountPrivileges
String[]
[ "INSERT", "REFERENCES" ]

The permission information configured for the column. Valid values (multiple selections allowed):

  • INSERT
  • REFERENCES
  • SELECT
  • UPDATE
ColumnName
String
column1
The name of the column for which column-level permissions are configured.
TableName
String
table1
The name of the table with column-level permission settings.

Sample request 

POST /?Action=DescribeDBAccountTableColumnInfo&Version=2022-01-01 HTTP/1.1
Content-Type: application/json
Host: rds-mysql.cn-beijing.volcengineapi.com
X-Date: 20211202T101010Z
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/rds_mysql/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c6458****
{
    "InstanceId": "mysql-d6ce108d742e",
    "DBName": "db1",
    "AccountName": "user2",
    "ColumnName": "column1",
    "TableLimit": 5
}

Sample response 

{
    "ResponseMetadata": {
        "RequestId": "20250413160415A912F3D18FFE92BF5C5F-38c330",
        "Action": "DescribeDBAccountTableColumnInfo",
        "Version": "2022-01-01",
        "Service": "rds_mysql",
        "Region": "cn-beijing"
    },
    "Result": {
        "TableInfos": [
            {
                "AccountPrivileges": [
                    "SELECT",
                    "INSERT",
                    "REFERENCES",
                    "CREATE VIEW",
                    "TRIGGER"
                ],
                "ColumnInfos": [
                    {
                        "AccountPrivileges": null,
                        "ColumnName": "column2"
                    }
                ],
                "TableName": "table1"
            },
            {
                "AccountPrivileges": [
                    "SELECT",
                    "INSERT",
                    "UPDATE",
                    "DELETE",
                    "CREATE",
                    "DROP",
                    "REFERENCES",
                    "INDEX",
                    "ALTER",
                    "CREATE VIEW",
                    "SHOW VIEW",
                    "TRIGGER"
                ],
                "ColumnInfos": [
                    {
                        "AccountPrivileges": null,
                        "ColumnName": "column2"
                    }
                ],
                "TableName": "table10"
            },
            {
                "AccountPrivileges": null,
                "ColumnInfos": [
                    {
                        "AccountPrivileges": [
                            "SELECT",
                            "INSERT",
                            "UPDATE",
                            "REFERENCES"
                        ],
                        "ColumnName": "column2"
                    }
                ],
                "TableName": "table2"
            },
            {
                "AccountPrivileges": null,
                "ColumnInfos": [
                    {
                        "AccountPrivileges": null,
                        "ColumnName": "column2"
                    }
                ],
                "TableName": "table3"
            },
            {
                "AccountPrivileges": null,
                "ColumnInfos": [
                    {
                        "AccountPrivileges": null,
                        "ColumnName": "column2"
                    }
                ],
                "TableName": "table4"
            }
        ]
    }
}

Error codes

For more details, refer to Error codes.

Last updated: 2025.07.07 15:52:02