ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-43
ALIAS Statements
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 ALIAS
The ADD ALIAS statement:
•
Creates a new entry in the ZNSALT table that allows the client to use the alias
username to log in or to qualify objects. An alias username is translated only once.
•
Causes objects created by the alias username to be stored as if they were created
by the corresponding logical username
•
Generates an error if alias-username already exists in the system catalog table
ZNSALT
•
Generates a warning if logical-username is not a valid NonStop ODBC Server
logical username
•
Generates a warning if profile-name is not a valid NonStop ODBC Server
profile
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server
•
Generates an error if you are not authorized to modify the system catalog or the
user associated with logical-username
Example
The following ADD ALIAS statement adds the alias name Jones for the logical
username SQL_Jones using the profile associated with SQL_Jones:
ADD ALIAS Jones NOS_USERNAME SQL_Jones PROFILE_NAME *
MODIFY ALIAS
The MODIFY ALIAS statement changes the mapping between an alias username and
a logical username or changes the profile name associated with an existing alias. (To
change the mapping between a logical username and a Guardian username, use the
MODIFY USER statement.)
To execute MODIFY ALIAS, you must be a privileged user or the user associated with
logical-username.
MODIFY ALIAS alias-username
[ NOS_USERNAME logical-username ]
[ CHANGE_PASSWORD_OPTION { 0 | 1 | 2 } ]
[ PROFILE profile-name ]
[ UPDATE_SYSTEM_CONFIG ]