ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-115
USER Statements
•
Generates an error if scs-processname and alias-username are not
mapped to each other and represented by an entry in ZNSUMAP
Example
REMOVE UMAP $myscs sql_dave
USER Statements
Use the following statements to map logical usernames to Guardian usernames:
•
ADD USER
•
MODIFY USER
•
REMOVE USER
ADD USER
The ADD USER statement associates a logical username with a Guardian username
and, optionally, with a profile. To execute ADD USER, you must be either the user
identified by guardian-username or be a privileged user.
logical-username
is an alphanumeric string up to 60 characters, beginning with a letter of the
alphabet and optionally containing hyphens (-), that specifies a logical username to
associate with guardian-username. The default for is NULL.
guardian-username
is an alphabetic string up to 17 characters in length that specifies the Guardian
username to associate with logical-username in the format:
group.user
An error occurs if guardian-username already exists in ZNSUS. The default is
the default for the current process.
ADD USER logical-username guardian-username
[ CHANGE_PASSWORD_OPTION { 0 | 1 | 2 } ]
[ PROFILE profilename ]
[ UPDATE_SYSTEM_CONFIG ]