Re: SQL to determine permissions?

systables which hold permissions can be found: select tabname from systables where tabname matches "*auth*" or tabname = "sysusers"may be a bit of here... V9.3 and bigger may have more. > current permissions in force for the current connection on a given object current... may not be entirely true... if one is connected with say select priv on table a and the dba in the meantime adds update permission, then the current session does not benefit from that, however it will be listed in the systabauth (i could be wrong here.... check the manual for it... ). When the session disconnects and the user logs on again, it'll benefit from the extra permission Superboer. William Fields schreef: > Anyone know if there's an Informix system table SQL that'll return the > current permissions in force for the current connection on a given object > (table,view,sp etc...)? > > Thanks. > > -- > William Fields > Code Contortionist > MCSD - Microsoft Visual FoxPro > US Bankruptcy Court > Phoenix, AZ > > ".dll hell - .rpm hell - whatever. > The grass is always greener"