SCHEMA_PRIVILEGES

This view contains information about the privileges in a given cluster.

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.
`TABLE_SCHEMA`	The name of the related schema (database) for a given 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 privilege can be granted by a given user.

Was this article helpful?