[#MXS-3832] Document privileges required for procs

[MXS-3832] Document privileges required for procs_priv system table Created: 2021-10-25 Updated: 2022-08-09 Resolved: 2021-11-09
Status:	Closed
Project:	MariaDB MaxScale
Component/s:	Authenticator, Documentation
Affects Version/s:	6.1.4
Fix Version/s:	2.5.17

Type:

Bug

Priority:

Major

Reporter:

Geoff Montee (Inactive)

Assignee:

markus makela

Resolution:

Fixed

Votes:

Labels:

None

Description

The KB currently says that the following privileges are required for the MaxScale user account:

CREATE USER 'maxscale'@'%' IDENTIFIED BY 'maxscale_pw';

GRANT SELECT ON mysql.user TO 'maxscale'@'%';

GRANT SELECT ON mysql.db TO 'maxscale'@'%';

GRANT SELECT ON mysql.tables_priv TO 'maxscale'@'%';

GRANT SELECT ON mysql.columns_priv TO 'maxscale'@'%';

GRANT SELECT ON mysql.proxies_priv TO 'maxscale'@'%';

GRANT SELECT ON mysql.roles_mapping TO 'maxscale'@'%';

GRANT SHOW DATABASES ON *.* TO 'maxscale'@'%';

It looks like the following privilege also needs to be added:

GRANT SELECT ON mysql.procs_priv TO 'maxscale'@'%';

This privilege is currently missing on the following KB pages:

The privilege is already correctly shown on the following KB pages:

Generated at Thu Feb 08 04:24:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.