Why Is MySQL User Global SELECT Privilege Needed On All Databases For MEM?
(Doc ID 2450752.1)
Last updated on FEBRUARY 27, 2020
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