Re: Role utilisation problem

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 > _____________________________________________________________________________ I use SE, which doesn't have roles. However, I have a little shell program which basically allows you to add and subtract privileges. I set up some "users" who never log in and grant them the privileges of a role. I then use my shell script to combine these and copy them to real users. It makes managing privileges a doddle. This might be a solution if you can't get the real roles to work. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/