MYSQL Data Source Spectrum Reports¶

MySQL versions later than 8.0 are not supported for Data Source Spectrum Reports.

The reports for All User and Admin Count, User Privilege Report, and User Granted Role and Table Count can be generated for the MYSQL data sources. The following permissions are required for the following MYSQL objects:

SELECT on mysql.user
SELECT on information_schema.USER_PRIVILEGES
SELECT on performance_schema.accounts
SELECT on performance_schema.host_cache
SELECT on performance_schema.events_statements_history
SELECT on performance_schema.global_status
SHOW DATABASES on .

These permissions are necessary for the SQL queries in the fetch_report methods of the various classes within DatabaseRepo. The queries access system tables and views to retrieve user, role, privilege, and login information, as well as query histories and global status metrics. These reports are explained in detail below.

All User and Admin Count¶

The report provides a summary of the number of admin and non-admin user accounts in a MYSQL database, along with details about the data source and a timestamp indicating when the data was recorded. It is useful for assessing the distribution of administrative and non-administrative users within the database.

User Privilege Report¶

The report provides information about user accounts in a MySQL database, including the number of roles granted to each user and the data source details. It is useful for tracking user privileges and understanding the structure of user roles within the database.

User Granted Role and Table Count¶

The report provides information about user accounts in a MySQL database including the number of roles granted to each user and the data source details. It is useful for tracking user privileges and understanding the structure of user roles within the database.