USAGE_PRIVILEGES

Information on all the USAGE privileges that the current authorization identifier has or which it has granted.

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

OBJECT_CATALOG

CHAR (18)

Database name

OBJECT_SCHEMA

CHAR (31)

Name of the schema containing the sort
sequence or character set to which the
privilege applies
Blanks for storage group

OBJECT_NAME

CHAR (18)

Name of the storage group, sort sequence or
character set to which the privilege applies

OBJECT_TYPE

CHAR (18)

Object to which the privilege applies:
STOGROUP
CHARACTER SET
COLLATION

PRIVILEGE_TYPE

CHAR (18)

USAGE

IS_GRANTABLE

VARCHAR (3)

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

Table 101: USAGE_PRIVILEGES view of the INFORMATION_SCHEMA