17.33. SHOW GRANTS
SHOW GRANTS ON ( [ TABLE ] table_name | ALL )
List the grants for the current user on the specified table in the current catalog.
ALL lists the grants for the current user on all the tables in all the schemas in the current catalog.
The command requires the current catalog to be set.
Ensure that authentication has been enabled before running any of the authorization
commands such as
List the grants for the current user on table
SHOW GRANTS ON TABLE ``orders``
List the grants for the current user on all tables:
SHOW GRANTS ON ALL;
Some connectors have no support for
See connector documentation for more details.