SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-17
COL_PRIVILEGES Table
COL_PRIVILEGES Table
COL_PRIVILEGES is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that stores grant information for columns in the catalog:
Grant information for entire tables is stored separately in the TABLE_PRIVILEGES
table.
Column Name Data Type Description
*1 TABLE_UID LARGEINT UID of table
*2 COLUMN_NUMBER INT Position within table (first column is 0)
*3 GRANTOR INT Security ID of grantor (or of owner if grantor
is super ID acting for owner)
*4 GRANTOR_TYPE CHAR(2) S if system grant
U if user grant
*5 GRANTEE INT If GRANTEE_TYPE is U, security ID of
grantee and link to TABLE_PRIVILEGES;
no meaning otherwise
*6 GRANTEE_TYPE CHAR(2) P if public grant
U if user grant
* 7 PRIVILEGE_TYPE CHAR(2) Privilege type:
S SELECT
I INSERT
D DELETE
U UPDATE
R REFERENCES
8 IS_GRANTABLE CHAR(2) Y if granted with grant option
N if not
* Indicates primary key