SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-30
TBL_PRIVILEGES Table
In version 1200 schemas, the primary key consists of the columns in the following
order:
1. CONSTRAINT_UID
2. CONSTRAINT_TYPE
3. TABLE_UID
In version 3000 and later schemas, the primary key consists of the columns in the
following order:
1. TABLE_UID
2. CONSTRAINT_UID
3. CONSTRAINT_TYPE
TBL_PRIVILEGES Table
TBL_PRIVILEGES is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that stores grant information for tables in the catalog:
9 ENFORCED CHAR(2) Reserved for future use.
10 VALIDATED CHAR(2) Reserved for future use.
11 LAST_VALIDATED LARGEINT Reserved for future use.
* Indicates primary key
Column Name Data Type Description
*1 GRANTOR INT Security ID of grantor (or of owner if grantor
is the super ID acting for owner)
*2 GRANTOR_TYPE CHAR(2) S if system grant
U if user grant
O if granted as schema owner
*3 GRANTEE INT If GRANTEE_TYPE is U, security ID of
grantee and link to COL_PRIVILEGES; no
meaning otherwise
*4 GRANTEE_TYPE CHAR(2) P if public grant
U if user grant
O if grantee is schema owner
*5 TABLE_UID LARGEINT UID of table
Column Name Data Type Description