权限一览表

具体权限的作用详见官方文档

GRANT 和 REVOKE 允许的静态权限

PrivilegeGrant Table ColumnContext
[ALL [PRIVILEGES]](https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_all)Synonym for “all privileges”Server administration
ALTERAlter\_privTables
ALTER ROUTINEAlter\_routine\_privStored routines
CREATECreate\_privDatabases, tables, or indexes
CREATE ROLECreate\_role\_privServer administration
CREATE ROUTINECreate\_routine\_privStored routines
CREATE TABLESPACECreate\_tablespace\_privServer administration
CREATE TEMPORARY TABLESCreate\_tmp\_table\_privTables
CREATE USERCreate\_user\_privServer administration
CREATE VIEWCreate\_view\_privViews
DELETEDelete\_privTables
DROPDrop\_privDatabases, tables, or views
DROP ROLEDrop\_role\_privServer administration
EVENTEvent\_privDatabases
EXECUTEExecute\_privStored routines
FILEFile\_privFile access on server host
GRANT OPTIONGrant\_privDatabases, tables, or stored routines
INDEXIndex\_privTables
INSERTInsert\_privTables or columns
LOCK TABLESLock\_tables\_privDatabases
PROCESSProcess\_privServer administration
PROXYSeeproxies\_priv tableServer administration
REFERENCESReferences\_privDatabases or tables
RELOADReload\_privServer administration
REPLICATION CLIENTRepl\_client\_privServer administration
REPLICATION SLAVERepl\_slave\_privServer administration
SELECTSelect\_privTables or columns
SHOW DATABASESShow\_db\_privServer administration
SHOW VIEWShow\_view\_privViews
SHUTDOWNShutdown\_privServer administration
SUPERSuper\_privServer administration
TRIGGERTrigger\_privTables
UPDATEUpdate\_privTables or columns
USAGESynonym for “no privileges”Server administration

GRANT 和 REVOKE 允许的动态权限

PrivilegeContext
APPLICATION\_PASSWORD\_ADMINDual password administration
AUDIT\_ABORT\_EXEMPTAllow queries blocked by audit log filter
AUDIT\_ADMINAudit log administration
AUTHENTICATION\_POLICY\_ADMINAuthentication administration
BACKUP\_ADMINBackup administration
BINLOG\_ADMINBackup and Replication administration
BINLOG\_ENCRYPTION\_ADMINBackup and Replication administration
CLONE\_ADMINClone administration
CONNECTION\_ADMINServer administration
ENCRYPTION\_KEY\_ADMINServer administration
FIREWALL\_ADMINFirewall administration
FIREWALL\_EXEMPTFirewall administration
FIREWALL\_USERFirewall administration
FLUSH\_OPTIMIZER\_COSTSServer administration
FLUSH\_STATUSServer administration
FLUSH\_TABLESServer administration
FLUSH\_USER\_RESOURCESServer administration
GROUP\_REPLICATION\_ADMINReplication administration
GROUP\_REPLICATION\_STREAMReplication administration
INNODB\_REDO\_LOG\_ARCHIVERedo log archiving administration
NDB\_STORED\_USERNDB Cluster
PASSWORDLESS\_USER\_ADMINAuthentication administration
PERSIST\_RO\_VARIABLES\_ADMINServer administration
REPLICATION\_APPLIERPRIVILEGE\_CHECKS\_USER for a replication channel
REPLICATION\_SLAVE\_ADMINReplication administration
RESOURCE\_GROUP\_ADMINResource group administration
RESOURCE\_GROUP\_USERResource group administration
ROLE\_ADMINServer administration
SESSION\_VARIABLES\_ADMINServer administration
SET\_USER\_IDServer administration
SHOW\_ROUTINEServer administration
SYSTEM\_USERServer administration
SYSTEM\_VARIABLES\_ADMINServer administration
TABLE\_ENCRYPTION\_ADMINServer administration
VERSION\_TOKEN\_ADMINServer administration
XA\_RECOVER\_ADMINServer administration
最后修改：2024 年 09 月 21 日
© 允许规范转载
如果觉得我的文章对你有用，请随意赞赏