Troubleshooting
Problem
You make a trusted context connection but when you run SET SESSIONAUTH userid you get this error: -389 No DBA permission.
Cause
The connection you made is not a trusted context connection.
- The domain(s) or IP address(es) defined in the ADDRESS attribute(s) of the trusted context object does not match the domain or IP address of your client.
- The userid defined in the USER or "BASED UPON CONNECTION USING SYSTEM AUTHID" clause of the trusted context object does not match the userid used by the client to establish the trusted context.
- The Informix JDBC driver is not version 3.70.JC1 or later.
- TRUSTED_CONTEXT is not set to true in the connection URL
- You are using WAS to connect but have not set ifxTRUSTED_CONTEXT to true to indicate to the database server you want a trusted context connection.
Resolving The Problem
- Use the ALTER TRUSTED CONTEXT command or DROP TRUSTED CONTEXT / CREATE TRUSTED CONTEXT to correct the ADDRESS entry.
- Use the ALTER TRUSTED CONTEXT command or DROP TRUSTED CONTEXT / CREATE TRUSTED CONTEXT to correct the USER or "BASED UPON CONNECTION USING SYSTEM AUTHID" clause.
- Install Informix JDBC driver version 3.70.JC1 or later.
- Set TRUSTED_CONTEXT=true in the connection URL like this:
jdbc:informix-sqli://hostname:portnumber/database_name:INFORMIXSERVER=server_name;TRUSTED_CONTEXT=TRUE;
- Create a string type custom property name ifxTRUSTED_CONTEXT and set it to true.
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.7;11.70","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
Informix Servers
Software version:
11.7, 11.70
Operating system(s):
AIX, HP-UX, Linux, OS X, Solaris, Windows
Document number:
487075
Modified date:
16 June 2018
UID
swg21620630
Manage My Notification Subscriptions