Loading... ## 权限一览表 > 具体权限的作用详见[官方文档](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html "官方文档") GRANT 和 REVOKE 允许的静态权限 | Privilege | Grant Table Column | Context | | ------------------------------------------------------------------------------------------------------------------------ | ------------------------------ | ------------------------------------- | | [ALL [PRIVILEGES]](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_all) | Synonym for “all privileges” | Server administration | | [ALTER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_alter) | Alter\_priv | Tables | | [ALTER ROUTINE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_alter-routine) | Alter\_routine\_priv | Stored routines | | [CREATE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_create) | Create\_priv | Databases, tables, or indexes | | [CREATE ROLE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_create-role) | Create\_role\_priv | Server administration | | [CREATE ROUTINE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_create-routine) | Create\_routine\_priv | Stored routines | | [CREATE TABLESPACE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_create-tablespace) | Create\_tablespace\_priv | Server administration | | [CREATE TEMPORARY TABLES](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_create-temporary-tables) | Create\_tmp\_table\_priv | Tables | | [CREATE USER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_create-user) | Create\_user\_priv | Server administration | | [CREATE VIEW](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_create-view) | Create\_view\_priv | Views | | [DELETE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_delete) | Delete\_priv | Tables | | [DROP](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_drop) | Drop\_priv | Databases, tables, or views | | [DROP ROLE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_drop-role) | Drop\_role\_priv | Server administration | | [EVENT](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_event) | Event\_priv | Databases | | [EXECUTE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_execute) | Execute\_priv | Stored routines | | [FILE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_file) | File\_priv | File access on server host | | [GRANT OPTION](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_grant-option) | Grant\_priv | Databases, tables, or stored routines | | [INDEX](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_index) | Index\_priv | Tables | | [INSERT](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_insert) | Insert\_priv | Tables or columns | | [LOCK TABLES](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_lock-tables) | Lock\_tables\_priv | Databases | | [PROCESS](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_process) | Process\_priv | Server administration | | [PROXY](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_proxy) | Seeproxies\_priv table | Server administration | | [REFERENCES](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_references) | References\_priv | Databases or tables | | [RELOAD](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_reload) | Reload\_priv | Server administration | | [REPLICATION CLIENT](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-client) | Repl\_client\_priv | Server administration | | [REPLICATION SLAVE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave) | Repl\_slave\_priv | Server administration | | [SELECT](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_select) | Select\_priv | Tables or columns | | [SHOW DATABASES](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_show-databases) | Show\_db\_priv | Server administration | | [SHOW VIEW](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_show-view) | Show\_view\_priv | Views | | [SHUTDOWN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_shutdown) | Shutdown\_priv | Server administration | | [SUPER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_super) | Super\_priv | Server administration | | [TRIGGER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_trigger) | Trigger\_priv | Tables | | [UPDATE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_update) | Update\_priv | Tables or columns | | [USAGE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_usage) | Synonym for “no privileges” | Server administration | GRANT 和 REVOKE 允许的动态权限 | Privilege | Context | | ---------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------- | | [APPLICATION\_PASSWORD\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_application-password-admin) | Dual password administration | | [AUDIT\_ABORT\_EXEMPT](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_audit-abort-exempt) | Allow queries blocked by audit log filter | | [AUDIT\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_audit-admin) | Audit log administration | | [AUTHENTICATION\_POLICY\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_authentication-policy-admin) | Authentication administration | | [BACKUP\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_backup-admin) | Backup administration | | [BINLOG\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_binlog-admin) | Backup and Replication administration | | [BINLOG\_ENCRYPTION\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_binlog-encryption-admin) | Backup and Replication administration | | [CLONE\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_clone-admin) | Clone administration | | [CONNECTION\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_connection-admin) | Server administration | | [ENCRYPTION\_KEY\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_encryption-key-admin) | Server administration | | [FIREWALL\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_firewall-admin) | Firewall administration | | [FIREWALL\_EXEMPT](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_firewall-exempt) | Firewall administration | | [FIREWALL\_USER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_firewall-user) | Firewall administration | | [FLUSH\_OPTIMIZER\_COSTS](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_flush-optimizer-costs) | Server administration | | [FLUSH\_STATUS](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_flush-status) | Server administration | | [FLUSH\_TABLES](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_flush-tables) | Server administration | | [FLUSH\_USER\_RESOURCES](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_flush-user-resources) | Server administration | | [GROUP\_REPLICATION\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_group-replication-admin) | Replication administration | | [GROUP\_REPLICATION\_STREAM](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_group-replication-stream) | Replication administration | | [INNODB\_REDO\_LOG\_ARCHIVE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_innodb-redo-log-archive) | Redo log archiving administration | | [NDB\_STORED\_USER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_ndb-stored-user) | NDB Cluster | | [PASSWORDLESS\_USER\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_passwordless-user-admin) | Authentication administration | | [PERSIST\_RO\_VARIABLES\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_persist-ro-variables-admin) | Server administration | | [REPLICATION\_APPLIER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-applier) | PRIVILEGE\_CHECKS\_USER for a replication channel | | [REPLICATION\_SLAVE\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave-admin) | Replication administration | | [RESOURCE\_GROUP\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_resource-group-admin) | Resource group administration | | [RESOURCE\_GROUP\_USER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_resource-group-user) | Resource group administration | | [ROLE\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_role-admin) | Server administration | | [SESSION\_VARIABLES\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_session-variables-admin) | Server administration | | [SET\_USER\_ID](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_set-user-id) | Server administration | | [SHOW\_ROUTINE](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_show-routine) | Server administration | | [SYSTEM\_USER](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_system-user) | Server administration | | [SYSTEM\_VARIABLES\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_system-variables-admin) | Server administration | | [TABLE\_ENCRYPTION\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_table-encryption-admin) | Server administration | | [VERSION\_TOKEN\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_version-token-admin) | Server administration | | [XA\_RECOVER\_ADMIN](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_xa-recover-admin) | Server administration | Last modification：September 21, 2024 © Allow specification reprint Like 如果觉得我的文章对你有用，请随意赞赏