This topic provides an overview of the permissions that ApsaraDB RDS for MySQL provides for both privileged and standard accounts.
Accounts and permissions
Account type | Permission | Operation | ||||
Privileged account | N/A | 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, and UPDATE | ||||
Standard account | Read-only | LOCK TABLES, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT, SELECT, and 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, and UPDATE | |||||
DDL-only | ALTER, ALTER ROUTINE, CREATE, CREATE VIEW, CREATE TEMPORARY TABLES, CREATE ROUTINE, DROP, INDEX, LOCK TABLES, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT, and SHOW VIEW | |||||
DML-only | CREATE TEMPORARY TABLES, DELETE, EVENT, EXECUTE, INSERT, LOCK TABLES, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT, SELECT, SHOW VIEW, TRIGGER, and UPDATE | |||||