ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-116
USER Statements
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 profilename
is an alphanumeric string up to 60 characters, beginning with a letter of the
alphabet and optionally containing hyphens (-), that identifies the profile record in
ZNSPROF to use when a user logs into the server with logical-username. An
error occurs if profilename already exists in ZNSPROF.
If you omit the PROFILE parameter, the profile name DEFAULT is used.
UPDATE_SYSTEM_CONFIG
resets the time to update system configuration values to the current time. This
option causes running system components to reread their configuration values on
the next polling cycle.
Considerations – ADD USER
The ADD USER statement:
•
Creates an entry in the ZNSUS table that associates logical-username with
guardian-username
•
Creates an entry in ZNSPROF for the default profile for this user
•
Generates an error if logical-username or guardian-username already
exists in ZNSUS
•
Generates an error if you are not the user identified by guardian-username or
not a privileged user
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server
•
If an ADD USER operation fails for any reason, the mapping tables are
unchanged.
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.