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.