Re: detail information of user's grant

andrew wrote: > > Hi, > How can I obtain information of user's grant for specific table? For example > grant and level of privileges are located in sysusers (I suppose), but that > is information for all database. Is a table, where this information is? The tables are: sysusers Database level systabauth Table level syscolauth Column level sysfragauth Fragment level sysroleauth Roles ??? Stored procedures (sysprocauth??) That's all I can remember off the top of my head (not in the orifice at the moment). Some may be plural (or not :). Don't you just love the naming conventions? :-O > Or the other way to obtain this information? Try: dbschema -d <database name> -p all I think roles is -r all, but running dbschema with no options will give you help. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+