[MXS-3832] Document privileges required for procs_priv system table - Jira

XML

Word

Printable

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:

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.