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.

USER_PRIVILEGES

Was this article helpful?

Was this article helpful?