SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-12
Definition Schema Tables
PRIVILEGED_USERS table. If the table is empty, then the Super ID can modify the
PRIVILEGED_USERS table.
Definition Schema Tables
ACCESS_PATHS Table
ACCESS_PATHS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that describes physical instances of data in the catalog. (A physical instance of data is
a simple table, an index, or a partition of a table or index.)
Column Name Data Type Description
*1 GRANTEE INT User ID of the user belonging to the user class.
*2 GRANTEE_TYPE CHAR(2) U = User
*3 USER CLASS CHAR(2) Denotes the user class.
SA = Security Administrator
4 GRANTOR INT User ID of the user that designated the
GRANTEE as a member of the user class.
5 GRANTOR_TYPE CHAR(2) U = User
6 IS_GRANTABLE CHAR(2) N = Not grantable
7 GRANT_TIME LARGEINT Specifies the Julian timestamp when the
GRANTOR designated (granted) the
GRANTEE as a member of the user class.
This attribute is useful for security auditing pur-
poses.
* Indicates primary key
Column Name Data Type Description
*1 TABLE_UID LARGEINT UID of base table; link to OBJECTS
*2 ACCESS_PATH_UID LARGEINT If path is index, UID of index;
otherwise, UID of base table
3 ACCESS_PATH_TYPE CHAR(2) BT Base Table
IX Index
4 COLUMN_COUNT INT Number of rows in table
ACCESS_PATH_COLUMNS directly
associated with this access path
5 UNIQUE_COLUMN_COUNT INT Number of rows in table
ACCESS_PATH_COLUMNS in
unique key for this access path
6 VALID_DATA CHAR(2) Y if valid data
N if not