USER_PRIVILEGES

This view contains information about the users and their related privileges in a given cluster.

If you (the current user) have the GRANT and SHOW METADATA permissions, you can see all user privileges. Otherwise, you will see only your own privileges.

Column Name

Description

GRANTEE

The user for which a given privilege has been granted.

TABLE_CATALOG

The name of the catalog of the related table for a given column privilege.

PRIVILEGE_TYPE

The type of privilege granted to a given user. See a list of all types in GRANT.

IS_GRANTABLE

Whether a given GRANTEE can grant permissions to other users.

Last modified: August 29, 2022

Was this article helpful?