All Products
Search
Document Center

ApsaraDB RDS:Account permissions

Last Updated:Jan 03, 2025

This topic provides an overview of the permissions that ApsaraDB RDS for MySQL provides for both privileged and standard accounts.

Accounts and permissions

For more information about privileged accounts and standard accounts, see Account types.

Account type

Permission

Operation

Privileged account

  • Read-only

  • Read/write

  • DDL-only

  • DML-only

ALTER,ALTER ROUTINE,CREATE,CREATE VIEW,CREATE ROUTINE,CREATE USER,CREATE TEMPORARY TABLES,DELETE,DROP,EVENT,EXECUTE,INDEX,INSERT,LOCK TABLES,PROCESS,RELOAD,REFERENCES,REPLICATION SLAVE,REPLICATION CLIENT,SELECT,SHOW VIEW,TRIGGER,UPDATE

Standard account

Read-only

REPLICATION SLAVE, REPLICATION CLIENT, SELECT, SHOW VIEW

Read/write

ALTER, ALTER ROUTINE, CREATE, CREATE TEMPORARY TABLES, CREATE VIEW, CREATE ROUTINE, DELETE, DROP, EVENT, EXECUTE, INSERT, INDEX, LOCK TABLES, PROCESS, REFERENCES, REPLICATION SLAVE, REPLICATION CLIENT, SELECT, SHOW VIEW, TRIGGER, UPDATE

DDL-only

ALTER, ALTER ROUTINE, CREATE, CREATE VIEW, CREATE TEMPORARY TABLES, CREATE ROUTINE, DROP, INDEX, LOCK TABLES, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT, SHOW VIEW

DML-only

CREATE TEMPORARY TABLES, DELETE, EVENT, EXECUTE, INSERT, LOCK TABLES, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT, SELECT, SHOW VIEW, TRIGGER, UPDATE