DB2 Universal Database for iSeries SQL Reference

SQLTABLEPRIVILEGES

The SQLTABLEPRIVILEGES view contains one row for every privilege granted on a table. The following table describes the columns in the view:

Table 145. SQLTABLEPRIVILEGES view

Column Name Data Type Description
TABLE_CAT VARCHAR(128) Relational database name
TABLE_SCHEM VARCHAR(128) Name of the SQL schema of the table.
TABLE_NAME VARCHAR(128) Name of the table.
GRANTOR VARCHAR(128)
Nullable
Reserved. Contains the null value.
GRANTEE VARCHAR(128) The user profile to which the privilege is granted.
PRIVILEGE VARCHAR(10) The privilege granted:

ALTER
The privilege to alter the table.

DELETE
The privilege to delete rows from the table.

INDEX
The privilege to create an index on the table.

INSERT
The privilege to insert rows into the table.

REFERENCES
The privilege to reference the table in a referential constraint.

SELECT
The privilege to select rows from the table.

UPDATE
The privilege to update the table.
IS_GRANTABLE VARCHAR(3) Indicates whether the privilege is grantable to other users.

NO
The privilege is not grantable.

YES
The privilege is grantable.
DBNAME VARCHAR(8)
Nullable
Reserved. Contains the null value.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]