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 accounts | N/A | SELECT | INSERT | UPDATE | DELETE | CREATE |
| DROP | RELOAD | PROCESS | REFERENCES | INDEX | ||
| ALTER | CREATE TEMPORARY TABLES | LOCK TABLES | EXECUTE | REPLICATION SLAVE | ||
| REPLICATION CLIENT | CREATE VIEW | SHOW VIEW | CREATE ROUTINE | ALTER ROUTINE | ||
| CREATE USER | EVENT | TRIGGER | ||||
| Standard accounts | Read-only | SELECT | LOCK TABLES | SHOW VIEW | PROCESS | REPLICATION SLAVE |
| REPLICATION CLIENT | ||||||
| Read/write | SELECT | INSERT | UPDATE | DELETE | CREATE | |
| DROP | REFERENCES | INDEX | ALTER | CREATE TEMPORARY TABLES | ||
| LOCK TABLES | EXECUTE | CREATE VIEW | SHOW VIEW | CREATE ROUTINE | ||
| ALTER ROUTINE | EVENT | TRIGGER | PROCESS | REPLICATION SLAVE | ||
| REPLICATION CLIENT | ||||||
| DDL-only | CREATE | DROP | INDEX | ALTER | CREATE TEMPORARY TABLES | |
| LOCK TABLES | CREATE VIEW | SHOW VIEW | CREATE ROUTINE | ALTER ROUTINE | ||
| PROCESS | REPLICATION SLAVE | REPLICATION CLIENT | ||||
| DML-only | SELECT | INSERT | UPDATE | DELETE | CREATE TEMPORARY TABLES | |
| LOCK TABLES | EXECUTE | SHOW VIEW | EVENT | TRIGGER | ||
| PROCESS | REPLICATION SLAVE | REPLICATION CLIENT | ||||