SET ROLE and SYSROLEAUTH

Posted in 2006

Topics: Performance & Tuning, Security, Permissions & Auditing

John — 3 May 2006 09:44:50 -0700 — source: Usenet: comp.databases.informix

Greetings, I have noticed that each execution of the SET ROLE command consistently takes 3 seconds to execute. It appears that this process causes 2 x sequential scans of SYSROLEAUTH on our system; this table has > 60K records .... hence the long elapsed time. Can anyone shed some light on this for me ? What exactly does the SET ROLE command do under the covers ? And why should it scan SYSROLEAUTH ? Regards, John

↪ replying to John

david@smooth1.co.uk — 3 May 2006 15:45:16 -0700 — source: Usenet: comp.databases.informix

Which Informix version? Log a support call. Any indexes on the table?