Privilege Granted to the Default User On MySQL Database Service: What the User Can Do and Can't Do (Doc ID 2707037.1)

Last updated on JANUARY 06, 2023

Applies to:

MySQL Database Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document describes what privileges are granted to the default user for MySQL Database Service, and understand what can be done, and cannot be done by the user.

Disclaimer: Starting from v8.0, some terms have been deprecated. Older releases will only use the deprecated terminology, and new releases will only use new terminology. Please see https://dev.mysql.com/doc/mysqld-version-reference/en/ for a complete list of those changes, and in which minor versions it happened.

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

Solution

Privileges Granted

Revoked Global Level Privileges

Static privileges:

Dynamic privileges:

Restricted Operations Example

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Privilege Granted to the Default User On MySQL Database Service: What the User Can Do and Can't Do (Doc ID 2707037.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!