ERROR 1141 (42000): There is no such grant defined for user

I keep getting this message when I attempt to show grants for a user."Error 1141 (42000): There is no such grant defined for user. Can you assist?

Answer Answered by William Hearn in this comment.

Found the issue. There was a management perl script that was expecting a user-host combination, and the user was actually a role. We added a decision block to account for roles in the user table. Thanks for your assistance.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.