Devart Forums

In testing the restore of database, if I delete user then run restore, user is added but no privileges. I have to reset them. The script includes this line:
GRANT USAGE ON *.* TO 'Vintage_Write'@'%' IDENTIFIED BY PASSWORD '*5DF2379450DE1FE82225FC5E38BEE0D9FC952776';

Not sure if it should be *.* since this user only has rights to 1 database (mariavintage).

Thanks for any help
Gary

When dumping with the doUsers option enabled, the following actions are executed:
- the list of all users is retrieved
- the SHOW GRANTS FOR query is executed for each user, and the result of the query is then added to the dump.