本文介绍RDS MySQL高权限账号和普通账号对应的权限。
账号权限列表
高权限账号与普通账号的详细说明，请参见账号类型。
账号类型 | 授权类型 | 权限 |
高权限账号 |
| 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 |
普通账号 | 只读 | REPLICATION SLAVE,REPLICATION CLIENT,SELECT,SHOW VIEW |
读写 | 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 | ALTER,ALTER ROUTINE,CREATE,CREATE VIEW,CREATE TEMPORARY TABLES,CREATE ROUTINE,DROP,INDEX,LOCK TABLES,PROCESS,REPLICATION SLAVE,REPLICATION CLIENT,SHOW VIEW | |
仅DML | CREATE TEMPORARY TABLES,DELETE,EVENT,EXECUTE,INSERT,LOCK TABLES,PROCESS,REPLICATION SLAVE,REPLICATION CLIENT,SELECT,SHOW VIEW,TRIGGER,UPDATE |