[Bug] After revoke role, the corresponding permissions are not displayed normally

[penglele]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

2.0.1-rc04

What's Wrong?

I have a question for revoke create user ceshilgp@'172%' IDENTIFIED by '123456'; create role role2; grant grant_priv on internal.db_ceshi.* to role 'role2'; grant 'role2' to ceshi_lgp@'172%'; revoke 'role2' from ceshi_lgp@'172%'; ----success show grants for ceshi_lgp@'172%'; ---The permissions for role2 remain in DatabasePrivs grant_priv

What You Expected?

After revoke role, the corresponding permissions are restored, and the show grant display is normal

How to Reproduce?

create user ceshilgp@'172%' IDENTIFIED by '123456'; create role role2; grant grant_priv on internal.db_ceshi.* to role 'role2'; grant 'role2' to ceshi_lgp@'172%'; revoke 'role2' from ceshi_lgp@'172%';
show grants for ceshi_lgp@'172%';

Anything Else?

No response

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[ixzc]

I didn't reproduce your question. you can try it again.