ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-118
USER Statements
Example
MODIFY USER SQL_Jones SQL.ODBC
REMOVE USER
The REMOVE USER statement removes the mapping between a logical username
and a Guardian username.
To execute REMOVE USER, you must be a privileged user.
logical-username
specifies the logical username you want to remove. The default is NULL.
CASCADE
removes all alias mappings in the ZNSALT table that refer to
logical-username.
Considerations – REMOVE USER
The REMOVE USER statement:
•
Removes the entry for logical-username from ZNSUS
•
Deletes from ZNSALT the self-referencing row that corresponds to
logical-username
•
Generates an error if logical-username cannot be found in ZNSUS
•
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
Example
REMOVE USER SQL_Smith
Note. REMOVE USER does not remove associated alias usernames. Deleting the logical
username has no effect on object attributes.
REMOVE USER logical-username [ CASCADE ]
[ UPDATE_SYSTEM_CONFIG ]