Overview

SHOW GRANTS [ ON [ TABLE ] table_name ]

Description

Lists the permissions of the current user on the specified table in the current catalog.

Examples

--- List the permissions of the current user on the table "orders"
SHOW GRANTS ON TABLE orders;

--- List the permissions of the current user on the current catalog
SHOW GRANTS;

Limits

Some connectors do not support SHOW GRANTS.