全部产品
Search
文档中心

云数据库 RDS:账号权限列表

更新时间:Oct 31, 2023

本文介绍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

普通账号

只读

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