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.

Last modified: August 29, 2022

Was this article helpful?