Forum / Password Vault Manager - Support

MySQL: New users not getting access to schema

  • Create an Issue
  • Cancel

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,

Clock4 yrs

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}'@'%';

Stefane Lavergne

signaturesignature

Clock4 yrs

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

Clock4 yrs

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

Clock4 yrs