ApsaraDB RDS：帳號許可權列表

帳號類型

授與類型

許可權

高許可權帳號

-

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

普通帳號

唯讀

LOCK TABLES,PROCESS,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