SYS_SPECIAL_PRIVILEGES

Information on special privileges.

Column name

Data type

Contents

GRANTEE

CHAR (18)

Authorization identifier granted the privilege or
PUBLIC

PRIVILEGE_TYPE

CHAR (18)

Privilege type:
CREATE USER
CREATE SCHEMA
CREATE STOGROUP
UTILITY

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 132: SYS_SPECIAL_PRIVILEGES view of the SYS_INFO_SCHEMA