My Oracle Support Banner

Why Is MySQL User Global SELECT Privilege Needed On All Databases For MEM? (Doc ID 2450752.1)

Last updated on MARCH 05, 2021

Applies to:

MySQL Enterprise Monitor - Version 3.0 and later
Information in this document applies to any platform.


On the manual for creation MySQL user accounts for MySQL Enterprise Monitor (MEM) Agent it's explained that a MySQL User with global SELECT privilege is needed.

Why does this user need SELECT privilege on all databases?
Is it possible to specialize the SELECTs on the needed databases (e.g. information_schema, performance_schema, mysql, sys)? 


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

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