Skip to Main Content
The world's most popular open source database
Contact MySQL  | 
Login  |  Register
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
HeatWave on AWS
  • Title and Copyright Information
  • Preface and Legal Notices
  • Overview
  • Getting Started
  • DB Systems
    • About DB Systems
      • Supported Shapes
      • MySQL Server
        • MySQL Server Versions
          • Server Versioning
          • Supported MySQL Server Versions
          • MySQL Versions Deprecation and Removal Policy in HeatWave Service
          • MySQL Version Support Schedule in HeatWave Service
        • Server Upgrades
          • Upgrading MySQL 8.0 BugFix to MySQL 8.4 LTS
          • Upgrading MySQL 8.4 LTS to MySQL 9.x Innovation
        • Server Error Logging
        • Unsupported MySQL Server Features
        • MySQL Storage Engines
        • Plugins and Components
        • MySQL Enterprise Audit
        • HeatWave on AWS Service Restrictions
        • Default MySQL Privileges
        • Reserved User Names
    • Launching a Starter DB System
    • Creating a DB System
    • Managing a DB System
      • Stopping, Starting, or Restarting a DB System
      • Editing a DB System
      • Update Networking
      • Update MySQL Configuration
      • Update MySQL Shape
      • Upgrade MySQL Version
      • Increasing DB System Storage
      • Deleting a DB System
    • Viewing DB System Details
      • MySQL DB System Details
  • HeatWave Clusters
  • Connecting to a DB System
  • PrivateLink
  • Importing Data
  • Inbound Replication
  • Manage Data in HeatWave
  • Running Queries
  • Autopilot Index Advisor
  • High Availability
  • HeatWave AutoML
  • HeatWave GenAI
  • System Variables
  • Events
  • Performance Monitoring
  • Backups
  • Configuration
  • User and Group Management
  • Account Management
  • Maintenance
  • Release Notes
Download this Manual
PDF (US Ltr) - 1.1Mb


HeatWave on AWS  /  ...  /  DB Systems  /  About DB Systems  /  MySQL Server  /  Default MySQL Privileges

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


PREV   HOME   UP   NEXT
Download this Manual
PDF (US Ltr) - 1.1Mb
Contact MySQL Sales
USA/Canada: +1-866-221-0634   (More Countries »)
  © 2025 Oracle

  • Products
  • HeatWave
  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster CGE
  • MySQL Embedded (OEM/ISV)
  • Services
  • Training
  • Certification
  • Support
  • Downloads
  • MySQL Community Server
  • MySQL NDB Cluster
  • MySQL Shell
  • MySQL Router
  • MySQL Workbench
  • Documentation
  • MySQL Reference Manual
  • MySQL Workbench
  • MySQL NDB Cluster
  • MySQL Connectors
  • Topic Guides
  • About MySQL
  • Contact Us
  • Blogs
  • How to Buy
  • Partners
  • Job Opportunities
  • Site Map
  © 2025 Oracle
Privacy / Do Not Sell My Info | Terms of Use | Trademark Policy |
Cookie Preferences