账号权限列表
所有文档

          云数据库 RDS

          账号权限列表

          本文介绍 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
          上一篇
          删除账号
          下一篇
          数据库管理