账号权限列表

更新时间：2024-08-01

本文介绍 RDS for MySQL 的 super 账号和普通账号对应的权限。

账号类型	权限类型	权限	说明
super 账号	-	SELECT	super 账号所有权限都是对所有库表授权，不仅仅是 select
		INSERT
		UPDATE
		DELETE
		CREATE
		DROP
		RELOAD
		PROCESS
		REFERENCES
		INDEX
		ALTER
		SUPER
		CREATE TEMPORARY TABLES
		LOCK TABLES
		EXECUTE
		REPLICATION SLAVE
		REPLICATION CLIENT
		CREATE VIEW
		SHOW VIEW
		CREATE ROUTINE
		ALTER ROUTINE
		CREATE USER
		EVENT
		TRIGGER
普通账号	读写账号	PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON .	. 表示对所有库表有权限
		SELECT ON performance_schema.*	对performance_schema系统库的权限
		ALL PRIVILEGES ON 业务库名.*	对指定业务库的权限
		SELECT ON mysql.func	对mysql系统库的部分表查询权限
		SELECT ON mysql.time_zone
		SELECT ON mysql.general_log
		SELECT ON mysql.proc
		SELECT ON mysql.time_zone_transition_type
		SELECT ON mysql.slow_log
		SELECT ON mysql.help_relation
		SELECT ON mysql.time_zone_transition
		SELECT ON mysql.time_zone_name
		SELECT ON mysql.help_topic
		SELECT ON mysql.help_keyword
		SELECT ON mysql.time_zone_leap_second
		SELECT ON mysql.help_category
		SELECT ON mysql.event
	只读账号	PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON .	. 表示对所有库表有权限
		SELECT ON performance_schema.*	对performance_schema系统库的权限
		SELECT, REFERENCES, SHOW VIEW ON 业务库名.*	对指定业务库的权限
		SELECT ON mysql.slow_log	对MySQL系统库的部分表查询权限
		SELECT ON mysql.time_zone_transition_type
		SELECT ON mysql.help_relation
		SELECT ON mysql.time_zone_leap_second
		SELECT ON mysql.event
		SELECT ON mysql.proc
		SELECT ON mysql.func
		SELECT ON mysql.time_zone
		SELECT ON mysql.help_category
		SELECT ON mysql.time_zone_transition
		SELECT ON mysql.general_log
		SELECT ON mysql.time_zone_name
		SELECT ON mysql.help_topic
		SELECT ON mysql.help_keyword

百度智能云

云数据库 RDS

云数据库 RDS

账号权限列表