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-12
Definition Schema Tables
by the GRANTOR user ID. The timestamp (GRANT_TIME) indicates the date and time
when the GRANTEE was granted the designation contained in the USER_CLASS
column. The set of user IDs in the GRANTEE column can modify the
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. Base tables and indexes have
physical instances. The actual locations of the physical instances are described in the
PARTITIONS table.
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; link to
PARTITIONS
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