Bug #89873 The mysql.session_user lacks privileges to persist variables
Submitted: 1 Mar 2018 15:29 Modified: 3 Jul 2018 15:30
Reporter: Pedro Gomes Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Group Replication Severity:S3 (Non-critical)
Version:8.0.5 OS:Any
Assigned to: CPU Architecture:Any

[1 Mar 2018 15:29] Pedro Gomes
Description:
With the arrival of SET PERSIST/PERSIST_ONLY the session user should allow the use of such tools in the advent of auto configuration features in the server/plugins.

As of now, attempts to do so will result in 
Access denied; you need SYSTEM_VARIABLES_ADMIN and PERSIST_RO_VARIABLES_ADMIN privileges for this operation
 

How to repeat:
Try to use SET PERSIST on sql_command_test.cc 

Suggested fix:
Add SYSTEM_VARIABLES_ADMIN and PERSIST_RO_VARIABLES_ADMIN privileges to the  mysql.session_user.
[3 Jul 2018 15:30] David Moss
Posted by developer:
 
Thank you for your feedback, this has been fixed in upcoming versions and the following was added to the 8.0.12 changelog:
The SYSTEM_VARIABLES_ADMIN and PERSIST_RO_VARIABLES_ADMIN privileges have been added to the mysql.session_user.