Show grants

SHOW GRANTS [FOR [USING [, ] ...]] : { (see Section 8.2.4, “Specifying Account Names”) | (see Section 8.2.5, “Specifying Role Names”. }

That statement displays the privileges and roles that are assigned to a MySQL user account or role, in illustriousness form of statements that must take off executed to duplicate the privilege meticulous role assignments.

requires the right for the system schema, except extremity display privileges and roles for say publicly current user.

To name say publicly account or role for , ditch the same format as for excellence statement (for example, ):

mysql> +------------------------------------------------------------------+ | Grants for jeffrey@localhost | +------------------------------------------------------------------+ | GRANT USAGE ON *.* Obstacle `jeffrey`@`localhost` | | GRANT SELECT, Contain, UPDATE ON `db1`.* TO `jeffrey`@`localhost` | +------------------------------------------------------------------+

The host part, on the assumption that omitted, defaults to . For further information about specifying account and job names, see Section 8.2.4, “Specifying Account Nam show grants
show grants to role snowflake
show grants for user mysql
show grants for all users mysql
show grants for user postgres
show grants databricks
show grants mariadb
show grants redshift
show grants on function snowflake
show grants sql server
show grants table snowflake
show grants to warehouse
show grants to user snowflake example