Account Management Statements Privilege Meaning and Grantable Levels FIREWALL_USER Enable firewall rule administration, self. Level: Global. FLUSH_OPTIMIZER_COSTS Enable optimizer cost reloading. Level: Global. FLUSH_STATUS Enable status indicator flushing. Level: Global. FLUSH_TABLES Enable table flushing. Level: Global. FLUSH_USER_RESOURCES Enable user-resource flushing. Level: Global. GROUP_REPLICATION_ADMIN Enable Group Replication control. Level: Global. INNODB_REDO_LOG_ENABLE Enable or disable redo logging. Level: Global. INNODB_REDO_LOG_ARCHIVE Enable redo log archiving administration. Level: Global. NDB_STORED_USER Enable sharing of user or role between SQL nodes (NDB Cluster). Level: Global. PERSIST_RO_VARIABLES_ADMIN Enable persisting read-only system variables. Level: Global. REPLICATION_APPLIER Act as the  PRIVILEGE_CHECKS_USER  for a replication channel. Level: Global. REPLICATION_SLAVE_ADMIN Enable regular replication control. Level: Global. RESOURCE_GROUP_ADMIN Enable resource group administration. Level: Global. RESOURCE_GROUP_USER Enable resource group administration. Level: Global. ROLE_ADMIN Enable roles to be granted or revoked, use of  WITH ADMIN OPTION . Level: Global. SESSION_VARIABLES_ADMIN Enable setting restricted session system variables. Level: Global. SET_USER_ID Enable setting non-self  DEFINER  values. Level: Global. SHOW_ROUTINE Enable access to stored routine definitions. Level: Global. SYSTEM_USER Designate account as system account. Level: Global. SYSTEM_VARIABLES_ADMIN Enable modifying or persisting global system variables. Level: Global. TABLE_ENCRYPTION_ADMIN Enable overriding default encryption settings. Level: Global. VERSION_TOKEN_ADMIN Enable use of Version Tokens functions. Level: Global. XA_RECOVER_ADMIN Enable  XA RECOVER  execution. Level: Global. A trigger is associated with a table. To create or drop a trigger, you must have the  TRIGGER  privilege for the table, not the trigger. 2869