ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-40
ZNSUS (For Logical Username to Guardian
Username Mapping)
ZNSUS (For Logical Username to Guardian Username Mapping)
The ZNSUS table maps logical ODBC or SQL Server usernames to their Guardian
username counterparts.
ZNSUS resides only in the subvolume of the system catalog.
The ZNSUSI1 index ensures that the NonStop ODBC Server NOS_UID is unique for
the system. ZNSUSI1 resides only in the subvolume of the system catalog.
The ZNSUSI2 index ensures that the Guardian username is unique for these user
mappings. ZNSUSI2 resides only in the subvolume of the system catalog.
Table 8-20. Description of ZNSUS
Column Name
Primary Key Unique Index
Data Type Description
NOS_USERNAME x – VARCHAR (60) Logical username.
G_USERNAME – x CHAR (17) Corresponding Guardian
username for the logical
username.
NOS_UID – x INT (2) UNSIGNED A unique ID, system-generated
during ADD USER.
LAST_UPDATED _ _ DATETIME YEAR
TO FRACTION (6)
Date and time this row was added
or last modified.
x Indicates the column is part of the primary key or is a unique index
– Indicates the column is not part of the primary key or is not a unique index