Hello,

Is there a config parameter, that disables the "set role ...".

When a user is in a role, the first thing he has to do is to run "set role rolename".

When this user connect with ODBC to run his queries, this is impossible.

Regards,

When you let the users connect to Informix via ODBC, you should consider to build the role assignment into your client app.

And if this is a third party tool, like Access.

.... then you work either with fixed username / password combinations, or you may consider to make a form in MS Access to let the user specify his/her role, which you may translate into a SET ROLE statement.