SYS_PRIVILEGES

Information on table and column privileges.

Column name

Data type

Contents

GRANTEE

CHAR (18)

Authorization identifier granted the privilege
or PUBLIC

TABLE_SCHEMA

CHAR (31)

Name of the schema containing the table or
column to which the privilege applies

TABLE_NAME

CHAR (31)

Name of the table to which the privilege
applies or for whose column the privilege
applies

COLUMN_NAME

CHAR (31)

Name of the column to which the privilege
was restricted
Blanks if the privilege applies to the whole
table

OBJECT_INDICATOR

CHAR (1)

T Row contains information on table

C Row contains information on column

PRIVILEGE_TYPE

CHAR (18)

Privilege type:
SELECT
INSERT
DELETE
UPDATE
REFERENCES

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 121: SYS_PRIVILEGES view of the SYS_INFO_SCHEMA