ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-42
ALIAS Statements
ADD ALIAS
The ADD ALIAS statement associates an alias username with a logical username and,
optionally, with a profile. An alias username cannot refer to another alias username.
To execute ADD ALIAS, you must be authorized to modify the system catalog or be the
user associated with logical-username.
alias-username
is an alphanumeric string up to 60 characters in length that specifies a unique alias
username to associate with logical-username. alias-username must begin
with an alphabetic character, followed by alphabetic, numeric, and underscore
characters.
NOS_USERNAME logical-username
is an alphanumeric string up to 60 characters in length that specifies a logical
username to associate with alias-username. logical-username must begin
with an alphabetic character, followed by alphabetic, numeric, and underscore
characters.
CHANGE_PASSWORD_OPTION { 0 | 1 | 2 }
specifies the level of notification sent to users for Safeguard passwords that are
expired or are about to expire:
PROFILE profile-name
specifies the name of a profile to associate with alias-username. The value
must be either an SQL identifier or an asterisk (*). An asterisk indicates that the
profile to use is to be determined at run time from the ZNSALT record in which
NOS_ALIASNAME is equated with logical-username.
If you omit profile-name, the profile name DEFAULT is used.
ADD ALIAS alias-username
[ NOS_USERNAME logical-username ]
[ CHANGE_PASSWORD_OPTION { 0 | 1 | 2 } ]
[ PROFILE profile-name ]
[ UPDATE_SYSTEM_CONFIG ]
0 No notification is sent. A user can log in only if the password is correct
and has not expired, including the grace period. This is the default.
1 Notification is sent if the password is still in the grace period. A user can
then change the password and log in.
2 Notification is sent if the password is about to expire or if it has expired
but is still in the grace period. If the password has not yet expired, the
user can change the password or cancel the dialog box. If the password
has already expired, the user must change the password immediately.