util.dump requires mysql.user read priv
Hello,
I would like to propagate using mysql.shell util.dump tools in developers' area (to migrate tables or databases). It's nice tool and it has many advantages... but, I cannot do this because of this error:
ERROR: Unable to check privileges for user 'user'@'localhost'. User requires SELECT privilege on mysql.* to obtain information about all roles.
For specific user, who is not administrator, I cannot give reading mysql schema privilege due security reason.
I don't see also any workaround.
Why for dumping single table or even schema, there is a need read whole mysql schema?
For mysqldump it's not needed.
Any tips how to use these tools by non-administrative accounts?
If not, then it's useless for devs.
Subject
Views
Written By
Posted
util.dump requires mysql.user read priv
296
December 14, 2025 01:35PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.