My Oracle Support Banner

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

Last updated on SEPTEMBER 25, 2018

Applies to:

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

Goal

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)? 

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
References


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