managing user accounts

[bobbybobbertson]

I know there are GRANT and REVOKE statements, but is there a statement to show all the current privelages a user has?

 

[piti]

there is the "SHOW GRANTS FOR user" command

 

[bobbybobbertson]

thank you!!!

 

[InnSun]

IS there a way to SHOW all users with privileges?

something like:

SHOW GRANTS FOR *;
or
SHOW GRANTS FOR ALL;
this syntax, of course, returns an error.

thanks in advance