3.1.2.9 Default MySQL Privileges

This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas. Revoked privileges cannot be granted to any MySQL user. For more information, see MySQL Privileges.

• Global Privileges Granted

  • ALTER

  • ALTER ROUTINE

  • CREATE

  • CREATE ROLE

  • CREATE ROUTINE

  • CREATE TEMPORARY TABLES

  • CREATE USER

  • CREATE VIEW

  • DELETE

  • DROP

  • DROP ROLE

  • EVENT

  • EXECUTE

  • INDEX

  • INSERT

  • LOCK TABLES

  • PROCESS

  • REFERENCES

  • REPLICATION CLIENT

  • REPLICATION SLAVE

  • SELECT

  • SHOW DATABASES

  • SHOW VIEW

  • TRIGGER

  • UPDATE

• Global Dynamic Privileges Granted

  • APPLICATION_PASSWORD_ADMIN

  • BACKUP_ADMIN

  • CONNECTION_ADMIN

  • FIREWALL_ADMIN

  • FIREWALL_USER

  • FLUSH_OPTIMIZER_COSTS

  • FLUSH_STATUS

  • FLUSH_TABLES

  • FLUSH_USER_RESOURCES

  • REPLICATION_APPLIER

  • ROLE_ADMIN

  • XA_RECOVER_ADMIN

• Privileges Revoked from mysql Schema

  • ALTER

  • ALTER ROUTINE

  • CREATE

  • CREATE ROUTINE

  • CREATE TEMPORARY TABLES

  • CREATE VIEW

  • DELETE

  • DROP

  • EVENT

  • EXECUTE

  • INDEX

  • INSERT

  • LOCK TABLES

  • REFERENCES

  • TRIGGER

  • UPDATE

• Privileges Revoked from sys Schema

  • ALTER

  • ALTER ROUTINE

  • CREATE

  • CREATE ROUTINE

  • CREATE TEMPORARY TABLES

  • CREATE VIEW

  • DROP

  • EVENT

  • INDEX

  • LOCK TABLES

  • REFERENCES

  • TRIGGER

Parent topic: MySQL Server