权限一览表

Privilege

Grant Table Column

Context

ALL [PRIVILEGES]

Synonym for “all privileges”

Server administration

ALTER

Alter_priv

Tables

ALTER ROUTINE

Alter_routine_priv

Stored routines

CREATE

Create_priv

Databases, tables, or indexes

CREATE ROLE

Create_role_priv

Server administration

CREATE ROUTINE

Create_routine_priv

Stored routines

CREATE TABLESPACE

Create_tablespace_priv

Server administration

CREATE TEMPORARY TABLES

Create_tmp_table_priv

Tables

CREATE USER

Create_user_priv

Server administration

CREATE VIEW

Create_view_priv

Views

DELETE

Delete_priv

Tables

DROP

Drop_priv

Databases, tables, or views

DROP ROLE

Drop_role_priv

Server administration

EVENT

Event_priv

Databases

EXECUTE

Execute_priv

Stored routines

FILE

File_priv

File access on server host

GRANT OPTION

Grant_priv

Databases, tables, or stored routines

INDEX

Index_priv

Tables

INSERT

Insert_priv

Tables or columns

LOCK TABLES

Lock_tables_priv

Databases

PROCESS

Process_priv

Server administration

PROXY

See proxies_priv

table

Server administration

REFERENCES

References_priv

Databases or tables

RELOAD

Reload_priv

Server administration

REPLICATION CLIENT

Repl_client_priv

Server administration

REPLICATION SLAVE

Repl_slave_priv

Server administration

SELECT

Select_priv

Tables or columns

SHOW DATABASES

Show_db_priv

Server administration

SHOW VIEW

Show_view_priv

Views

SHUTDOWN

Shutdown_priv

Server administration

SUPER

Super_priv

Server administration

TRIGGER

Trigger_priv

Tables

UPDATE

Update_priv

Tables or columns

USAGE

Synonym for “no privileges”

Server administration

Privilege

Context

APPLICATION_PASSWORD_ADMIN

Dual password administration

AUDIT_ABORT_EXEMPT

Allow queries blocked by audit log filter

AUDIT_ADMIN

Audit log administration

AUTHENTICATION_POLICY_ADMIN

Authentication administration

BACKUP_ADMIN

Backup administration

BINLOG_ADMIN

Backup and Replication administration

BINLOG_ENCRYPTION_ADMIN

Backup and Replication administration

CLONE_ADMIN

Clone administration

CONNECTION_ADMIN

Server administration

ENCRYPTION_KEY_ADMIN

Server administration

FIREWALL_ADMIN

Firewall administration

FIREWALL_EXEMPT

Firewall administration

FIREWALL_USER

Firewall administration

FLUSH_OPTIMIZER_COSTS

Server administration

FLUSH_STATUS

Server administration

FLUSH_TABLES

Server administration

FLUSH_USER_RESOURCES

Server administration

GROUP_REPLICATION_ADMIN

Replication administration

GROUP_REPLICATION_STREAM

Replication administration

INNODB_REDO_LOG_ARCHIVE

Redo log archiving administration

NDB_STORED_USER

NDB Cluster

PASSWORDLESS_USER_ADMIN

Authentication administration

PERSIST_RO_VARIABLES_ADMIN

Server administration

REPLICATION_APPLIER

PRIVILEGE_CHECKS_USER

for a replication channel

REPLICATION_SLAVE_ADMIN

Replication administration

RESOURCE_GROUP_ADMIN

Resource group administration

RESOURCE_GROUP_USER

Resource group administration

ROLE_ADMIN

Server administration

SESSION_VARIABLES_ADMIN

Server administration

SET_USER_ID

Server administration

SHOW_ROUTINE

Server administration

SYSTEM_USER

Server administration

SYSTEM_VARIABLES_ADMIN

Server administration

TABLE_ENCRYPTION_ADMIN

Server administration

VERSION_TOKEN_ADMIN

Server administration

XA_RECOVER_ADMIN

Server administration