Re: ACE reports and SET ROLE

Jonathan Leffler wrote: > 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. > I don't have ACE, so I'm not sure if this will actually work, but ... Create a stored procedure in dbaccess: CREATE PROCEDURE set_role_xxx() RETURNING INTEGER; SET ROLE "xxx"; RETURN 0; END PROCEDURE; and, in ace: SELECT set_role_xxx() dummy FROM systables WHERE tabid = 1 INTO TEMP dummy WITH NO LOG; hth -- rh