Re: Role utilisation problem
Hi, I have been doing a lot of Brio/Informix consulting lately and found a way to use "SET ROLE" in Brio. In Brio Designer, when greating the report (bqy file) go to DataModel -> DataModel preferences -> Auditing Options ->Logon and define a SQL statement to use when the user log's on to run the report like "SET ROLE XXXX". Regards - Lester 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. > > Did somebody ever experience this kind of problem ? What workaround have you > found ? > > Thanks for your help. > Jean-Francois. > _____________________________________________________________________________ > Jean-Francois LE CARRE PETIT > IT-ESO Production Engineering Grenoble > RDBMS Team > /\\ H E W L E T T /\\/\\ Phone: (+33) 04 76 14 4149 > /\\ / \\ P A C K A R D /\\/ / \\ Fax: (+33) 04 76 14 1207 > / \\/\\/ \\ GRENOBLE / \\/ \\ Telnet/VM: 779-4149 > / \\ \\ \\___________/ \\ \\_ SharedX: goelo.grenoble.hp.com:0.0 > > Email: jean-francois_le-carre-petit@non-hp-france-om4.om.hp.com > _____________________________________________________________________________ -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 Grant group privileges for Informix databases with DB Privileges Visit our Web page: www.advancedatatools.com Washington Area Informix User Group: www.iiug.org/~waiug/ ______________________________________________________________________