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

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-11
SCHEMA_REPLICAS Table
Schema names that are regular identifiers are stored in uppercase letters. Schema
names that are delimited identifiers are stored as is, without surrounding quotation
marks.
SCHEMA_REPLICAS Table
SCHEMA_REPLICAS is a metadata table in
NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA that lists locations of all replicas
for all schemas that have definitions on the node.
System Security Schema Tables
MGM_PRIVILEGES
The MGM_PRIVILEGES is a metadata table, introduced in version 3100, stores node-
wide user privileges.
PRIVILEGED_USERS TABLE
The PRIVILEGED_USERS metadata table, introduced in version 3100, consists of
rows of GRANTEE user IDs that are designated as members of a privileged user class
Column Name Data Type Description
*1 SCHEMA_UID LARGEINT UID of schema; link to SCHEMATA
*2 NODE_NAME CHAR(8) Expand node name of node where
replica resides, including leading “\”
(backslash)
* Indicates primary key
Column Name Data Type Description
1 GRANTOR INT Security ID of the grantor.
2 GRANTOR_TYPE CHAR(2) O if grantor is a catalog owner
U if grantor is a Security Administrator
*3 GRANTEE INT Security ID of the grantee.
4 GRANTEE_TYPE CHAR(2) U if user grant.
*5 PRIVILEGE_TYPE CHAR(2) CC if Create Catalog
CS if Create Schema
* 6 TARGET_UID LARGEINT -1 when the privilege type is CC
UID of target catalog, when the privilege type
is CS
7 GRANT_TIMESTAMP LARGEINT Specifies the time when the GRANTOR
granted the privilege to the GRANTEE.
8 IS_GRANTABLE CHAR(2) Reserved for future use.
* Indicates primary key