Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.