SQL/MX Connectivity Service Manual (SQL/MX 2.x)
Overview of MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
1-7
Operation Access Controls
This setting directs SQLConnect, SQLBrowseConnect and SQLDriverConnect to
return SQL_SUCCESS_WITH_INFO with one of these warnings:
•
[WARNING 8857] Password to Expire in n days, n hours, n minutes. (If the
password expires in less than two days.)
or
•
[WARNING 8837] CLI Authorization failure: Error 48 with status 11 was
returned by Safecom. (If the password is expired and in the grace period.)
2. If the application uses SQLDriverConnect with the SQL_DRIVER_PROMPT
attribute, the ODBC/MX driver prompts the user to change the password.
The user has these options:
•
Cancel the password change and proceed with the current session.
•
Change the password by providing the old and new passwords. If an invalid
password is entered, the connection is terminated.
Operation Access Controls
You must use an ID created under the super group when installing MXCS. Starting the
association server requires that you are logged on with a user ID that has Guardian
access to run the MXOAS file. Thereafter, a user ID with MXCS OPERATOR
permission can enable and disable the MXCS service and manage MXCS from
NSM/web or MXCI. To perform any operation in MXCS, you must have the correct
access privileges to NonStop SQL catalogs, MXCS catalogs, and individual NonStop
SQL objects. A user ID with OPERATOR permission is the only user ID that can
manage MXCS.
Controlling who can manage the MXCS service
MXCS users have access permissions based on the security values for their Guardian
user ID. PUBLIC has USER permission and the super ID has OPERATOR permission
by default.
Permissions can be assigned and changed using NSM/web only by the super ID. All
other users can view permissions but not assign or change them.
There are two permissions: