CATALOG_PRIVILEGES

Information on the database privileges available to the current authorization identifier or which can be granted by the current authorization identifier.

Column name

Data type

Contents

GRANTOR

CHAR (18)

Authorization identifier that granted
the privilege or _SYSTEM

GRANTEE

CHAR (18)

Authorization identifier granted the
privilege or PUBLIC

CATALOG_NAME

CHAR (18)

Database name

PRIVILEGE_TYPE

CHAR (18)

Privilege type:
CREATE USER
CREATE SCHEMA
CREATE STOGROUP
UTILITY

IS_GRANTABLE

VARCHAR (3)

YES	The authorization identifier has GRANT authorization for the privilege
NO	No GRANT authorization

Table 65: CATALOG_PRIVILEGES view of the INFORMATION_SCHEMA