ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-11
ZNSALT (For Alternate Usernames)
ZNSALT (For Alternate Usernames)
The ZNSALT table maps alternate usernames to ODBC or SQL Server logical
username. A user can designate different profile descriptions for use at session
initiation for the same NonStop ODBC Server logical use name. More than one alias
can point to the same profile and to the same logical username. A ZNSALT record is
automatically added for each record added to the ZNSUS table.
ZNSALT resides only in the subvolume of the system catalog.
The index ZNSALTI1 ensures that the NonStop ODBC Server logical username is
unique for the system. ZNSALTI1 resides only in the subvolume of the system catalog.
Table 8-5. Description of ZNSALT
Column Name
Primary Key Unique Index
Data Type Description
NOS_ALIASNAME
x–
VARCHAR (60) Alias username that can be
used in place of the logical
username for login (user
authentication) or object refer-
ence. It is unique within a Non-
Stop ODBC Server installation.
NOS_USERNAME
––
VARCHAR (60) Logical username.
PROFILE_NAME
––
VARCHAR (60) Profile to be used by the
NonStop ODBC Server process
when a client connects using
this alias username.
LAST_UPDATED
––
DATETIME YEAR
TO FRACTION (6)
Date and time this row was
added or last modified.
CHANGE_PASSWORD_O
PTION
--
CHAR(1) Level of notification sent to
users for expired (or about to
expire) Safeguard passwords:
0-No notification is sent (the
default).
1-Notification is sent if the
password is in the grace period.
2-Notification is sent if the
password is about to expire or if
it has expired but is still in the
grace period.
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