ACE reports and SET ROLE

Hi, Anyone who knows if it is possible to use 'SET ROLE <rolename>' using I-SQL and ACE reports. We are running IDS 9.40.FC4 and I-SQL INFORMIX-SQL Version 7.30.UC7 . regards, Bjarne Wilken Jensen DatabaseAdm. - IT-produktion. Alm. Brand Forsikring A/S Midtermolen 7 DK-2100 K'benhavn ' Tlf: +45 3547 7771 E-Mail: abrbwj@AlmBrand.Dk sending to informix-list

bjarne.wilken.jensen@almbrand.dk wrote: > Anyone who knows if it is possible to use 'SET ROLE <rolename>' using > I-SQL and ACE reports. > > We are running IDS 9.40.FC4 and I-SQL INFORMIX-SQL Version 7.30.UC7 . Try running strings on $INFORMIXDIR/bin/sacego and grep for SACE; see if anything useful pops out at you (SACEISOL is isolation level). The last time the question was asked (1998), I believe the answer was No - that's the implications of the record I see at: http://groups.google.com/advanced_group_search searching for ACE and ROLE and group=comp.databases.informix. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/