SHOW GRANTS#
Примечание
Ниже приведена оригинальная документация Trino. Скоро мы ее переведем на русский язык и дополним полезными примерами.
Синтаксис#
SHOW GRANTS [ ON [ TABLE ] table_name ]
Описание#
List the grants for the current user on the specified table in the current catalog.
If no table name is specified, the command lists the grants for the current user on all the tables in all schemas of 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.
Примеры#
List the grants for the current user on table orders:
SHOW GRANTS ON TABLE orders;
List the grants for the current user on all the tables in all schemas of the current catalog:
SHOW GRANTS;
Limitations#
Some connectors have no support for SHOW GRANTS.
See connector documentation for more details.