Devolutions ForumDevolutions Forum

MySQL: New users not getting access to schema

avatar
tspaziani

Hello,

I recently installed Password Vault on MySQL. The datasource created the schema just fine and my admin user is able to do everything. However, when adding a new user, while it creates the user in MySQL just fine, its not granting them access to the schema so they can't login. I have to go in manually to the database and issue the grant command myself to the new user to get them connected.

When I run ">show grants for 'user'@'%'; I get
GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY ......

Usage according to mysql is no access. I need to GRANT ALL ON 'passvault'.* to 'user'@'%' for them to work.

Am I missing a step or is this a bug?

Thanks,

All Comments (3)

avatar
Stéfane Lavergne

Make sure the initial admin user has grant privileges (WITH GRANT OPTION).
When, using Password Vault, you create a new user the system will try to grant the following:

Admin user
GRANT ALL ON *.* TO '{0}'@'%' WITH GRANT OPTION;
Non admin user:
REVOKE ALL ON *.* FROM '{0}'@'%';
GRANT SELECT, INSERT, DELETE, UPDATE ON '{0}'.* TO '{1}'@'%';
GRANT EXECUTE ON '{0}'.* TO '{1}'@'%';

Stéfane Lavergne

avatar
tspaziani

Thanks! I'll give that a shot, I may have forgotten the "with grant option" on the initial admin user.

avatar
tspaziani

Yup that did the trick! Thanks for the quick response!