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