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

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-11
SCHEMA_REPLICAS Table
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
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 the
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 SA
*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