add utility-user-privileges to grant rights to utility user

Registered by George Ormond Lorch III

internal 23597

Add another option --utility-user-privileges that allows a csv list of extra rights to grant to the utility user. For example:
--utility-user=jorge --utility-user-password=barbeque --utility-user-privileges="CREATE,
DROP, LOCK TABLES"

This is based on the completed utility user feature https://blueprints.launchpad.net/percona-server/+spec/5-5-utility-user.

There will be an interesting interaction between --utility-user-schema-access and certain additional privileges such as CREATE, INSERT, DELETE, ALTER and DROP. If the utility user is granted access to a specific schema via schema-access, the user will already have all of the mentioned privileges on that schema. The user will NOT need explicit schema access via --utility-user-schema-access to execute any additional privileges granted via the --utility-user-privileges option.

Supported values for the privileges list:
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,RELOAD,SHUTDOWN,PROCESS,FILE,
GRANT,REFERENCES,INDEX,ALTER,SHOW DATABASES,SUPER,
CREATE TEMPORARY TABLES,LOCK TABLES,EXECUTE,REPLICATION SLAVE,
REPLICATION CLIENT,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE,
CREATE USER,EVENT,TRIGGER,CREATE TABLESPACE

Blueprint information

Status:
Complete
Approver:
Alexey Kopytov
Priority:
Medium
Drafter:
George Ormond Lorch III
Direction:
Approved
Assignee:
George Ormond Lorch III
Definition:
Approved
Series goal:
Accepted for 5.5
Implementation:
Implemented
Milestone target:
milestone icon 5.5.34-32.0
Started by
Laurynas Biveinis
Completed by
Laurynas Biveinis

Sprints

Whiteboard

As suggested in the MP, --utility-user-privileges would be a more intuitive name than --utility-user-access.

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.