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-31
TBL_PRIVILEGES Table
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:
1. TABLE_UID
2. GRANTOR
3. GRANTOR_TYPE
4. GRANTEE
5. GRANTEE_TYPE
6. PRIVILEGE_TYPE
*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
Column Name Data Type Description