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