SYS_USAGE_PRIVILEGES

Information on the USAGE privilege.

Column name

Data type

Contents

GRANTEE

CHAR (18)

Authorization identifier granted the privilege or
PUBLIC

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

GRANTOR

CHAR (18)

Authorization identifier that granted the
privilege or _SYSTEM

IS_GRANTABLE

VARCHAR (3)

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

Table 138: SYS_USAGE_PRIVILEGES view of the SYS_INFO_SCHEMA