ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-117
USER Statements
Example
In the following example, ADD USER defines a user whose logical username is
SQL_Jones and whose Guardian username is SQL.Jones. Jones uses the profile
record PERSNL.
ADD USER SQL_Jones SQL.Jones PROFILE persnl
MODIFY USER
The MODIFY USER statement changes the logical username associated with a
particular Guardian username.
To execute MODIFY USER, you must 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.
Considerations – MODIFY USER
The MODIFY USER statement:
•
Changes the logical guardian-username attributes in ZNSUS
•
If you change guardian-username, updates the ownership of NonStop ODBC
Server mapping table objects when the system catalog is next refreshed
•
Generates an error if logical-username cannot be found
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server
•
Generates an error if you are not a privileged user
Note. To change the profile name associated with a logical username, use MODIFY ALIAS.
MODIFY USER logical-username guardian-username
[ UPDATE_SYSTEM_CONFIG ]