TABLE_PRIVILEGES

Information on all the table 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

TABLE_CATALOG

CHAR (18)

Database name

TABLE_SCHEMA

CHAR (31)

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

TABLE_NAME

CHAR (31)

Name of the table to which the privilege applies

PRIVILEGE_TYPE

CHAR (18)

Privilege type:
SELECT
INSERT
DELETE
UPDATE
REFERENCES

IS_GRANTABLE

VARCHAR (3)

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

Table 99: TABLE_PRIVILEGES view of the INFORMATION_SCHEMA