Skip to main content
Version: Latest-3.3

schema_privileges

schema_privileges provides information about database privileges.

The following fields are provided in schema_privileges:

FieldDescription
GRANTEEThe name of the user to which the privilege is granted.
TABLE_CATALOGThe name of the catalog to which the schema belongs. This value is always def.
TABLE_SCHEMAThe name of the schema.
PRIVILEGE_TYPEThe privilege granted. Each row lists a single privilege, so there is one row per schema privilege held by the grantee.
IS_GRANTABLEYES if the user has the GRANT OPTION privilege, NO otherwise. The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT OPTION'.