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:










