Re: SET ROLE and SYSROLEAUTH

Posted in 2006

John — 11 May 2006 00:14:26 -0700 — source: Usenet: comp.databases.informix

Hi We are using IDS 7.3.1. Our DBA has alerted Tech Support (no response yet) Yes - SYSROLEAUTH appears to be uniquely indexed on rolename and grantee. Ordinary selects executed against this table with rolename and grantee do not sequentially scan. Hmmmmm ... John