Inspect the effective privileges granted to an account.

Section: grants and roles

Show grants for a user

sql
sql
SHOW GRANTS FOR 'app_user'@'%';
Explanation

Always verify grants after provisioning service accounts.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing grants and roles
Grant privileges on one database
Allow an app account to use one schema.
OpenIn sheetsqlsame section
Revoke privileges
Remove previously granted rights.
OpenIn sheetsqlsame section
Grant all privileges on a database
Give broad schema-level rights.
OpenIn sheetsqlsame section
Reload grant tables
Refresh privilege data after direct system-table changes.
OpenIn sheetsqlsame section
Create a user
Create an account identified by user name and host.
Change a user's password
Rotate credentials for an existing account.