Re: Role utilisation problem

On Fri, 17 Apr 1998 12:21:55 +0200, JEAN-FRANCOIS_LE-CARRE-PETIT@Non-HP-France-om4.om.hp.com wrote: > >Hello, > >I have a problem with the utilisation of the roles with Informix-Online DS >7.23.UC4. > >Some roles have been defined and as the documentation explains, the grant >instruction is not enough for the granted user to get the permissions (like >oracle). He will have to run the set role instruction in the SQL statement. > >But, the users use client report tools like brio query or information access >where they can't add an sql statement. So those users can never be really granted >with the roles permissions. > >Informix tech-support told me that this is a feature request that is being >studied at the moment. They don't know if they will develop this feature. May be they will one day understand that this is available right now and that they should change vendor of their connectivity software, particularly their ODBC driver - just may be... >Did somebody ever experience this kind of problem ? What workaround have you >found ? You don't need a work arround at all. If you use any deasent ODBC driver it will support sending such SQL statements to the database upon connection from any user. It will be easy for you to set up different sets of sql-statements depending on the user, where they log in from and what application they run. Just check the FAQ under "Third party tools" for at least one ODBC driver that have this built in. >Thanks for your help. >Jean-Francois. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)