Informix Error -950: User username is not known on the database server.
Cause and resolution
User username is not known on the database server.
This statement refers to a database on another computer system, but the other database server does not accept your account name. You must have a valid trusted login identity on any database server you access remotely. See your database administrator about putting your login ID in 'sysuser:sysauth' on the remote server. This message appears on PAM enabled servers.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-950 fires when a statement references a database on another computer system, but that remote server doesn't recognize the connecting account — per the official guidance, a valid trusted login identity is required on every database server accessed remotely; this message specifically appears on PAM-enabled servers.
- No trusted login identity for this account on the remote server, per the official guidance — the direct, only cause.
- PAM (Pluggable Authentication Modules) configured on the remote server, per the official guidance's specific note, with the connecting account not recognized under that authentication mechanism.
Solutions / Resolution
- Ask the database administrator to put your login ID in
sysuser:sysauthon the remote server, per the official guidance — this is the documented, specific resolution. - Confirm whether the remote server has PAM enabled, per the official guidance's note, since that's specifically when this message appears — the underlying account-recognition requirement is the same either way.
Examples
N/A
A remote-server account-authorization problem — escalate to the DBA for that specific server,
per the official guidance's sysuser:sysauth pointer.
Diagnostic Checks
- Identify the specific remote server named in the failing statement.
- Escalate to that server's DBA to add the account to
sysuser:sysauththere.
Related Errors / Related Topics
- -763 — "Error in auditing environment initialization." A related security-configuration error, about secure-server connection problems more generally, escalated similarly to the security administrator/DBA.
Escalate to the remote server's DBA to add the account to sysuser:sysauth there — this is a
remote-side authorization gap, not a local configuration issue.