SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-31
TBL_PRIVILEGES Table
TBL_PRIVILEGES Table
TBL_PRIVILEGES is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that stores grant information for tables in the catalog:
Grant information for individual columns is stored separately in the COL_PRIVILEGES
table.
All character columns store letters in uppercase except for GRANTOR and GRANTEE.
In version 1200 schemas, the primary key consists of the columns in the following
order:
1. GRANTOR
2. GRANTOR_TYPE
3. GRANTEE
4. GRANTEE_TYPE
5. TABLE_UID
6. PRIVILEGE_TYPE
In version 3000 and later version schemas, the primary key consists of the columns in
the following order:
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
*6 PRIVILEGE_TYPE CHAR(2) Privilege type:
S SELECT
I INSERT
D DELETE
U UPDATE
R REFERENCES
E EXECUTE (for stored procedures)
7 IS_GRANTABLE CHAR(2) Y if granted with grant option
N if not
* Indicates primary key