Four Js Development Tools Forum

Hi.

There is a major new feature in Informix 11.70 called "Trusted-context objects and trusted connections".  The client software must be able to do this:

CONNECT TO "mydb" TRUSTED;

Are there plans to implement this in Genero?

http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.sec.doc/ids_tru_001.htm

Hello Snorri,


You are right this is a major feature in IDS 11.70, the implementation is not yet planned in Genero.

We will begin the feature request process :

• Create a feature request and send to you the feature number.
• Evaluate the feasibility of the feature.
• If it is feasible we will plan it in a future release.

I keep you posted for the feature number.


Thank you,

Olivier ECKERT - Four Js support team

Hello Snorri,


The Four Js feature request number : "#20085 : Support INFORMIX 11.70 trusted connections" has been registered.

We are are working on the feasibility evaluation.

If other customers are interested in this feature, please send an email to your local support center.
We will add your company name in the wish list of this feature request #20085.

Thank you and regards,

Olivier ECKERT - Four Js support team

From my quick read of the feature, I believe this would benefit Web Services.  Correct me if I am wrong but a web service function could change the "user" that is connected to the database by executing a

SET SESSION AUTHORIZATION TO 'user';

where user is passed via the web service call, as opposed to currently the web service would have to DISCONNECT and CONNECT again using the new user which normally has some overhead.

This allows you to then use USER in your sql and/or triggers knowing that it relates to the person running the application, and not the process owner of the web service.

Ruben, you are spot on. Web services will benefit greatly from this. This basically gives you application based security.

Regards,
-Snorri

We are looking at trusted connections...

Note that you have to install IDS 11.70.XC2 to use this feature, I faced a bug in 11.70.UC1 on Linux:

CREATE USER statement failed with syntax error...

Fixed in 11.70.UC2...

Seb

By reading the documentation section about CREATE USER (mapped and internally authenticated users), it appears that this feature was introduced in the 11.70.xC2 release and was not in 11.70.xC1 ... So it's not a bug, CREATE USER was not existing in 11.70.xC1.

The fact that CREATE TRUSTED CONTEXT is supported in 11.70.xC1 confused me... :-(

Seb