Re: Retrieving user privileges via sql

Posted in 2003

preetinder dhaliwal — Wed, 13 Aug 2003 15:55:17 -0700 — source: Usenet: comp.databases.informix

sysusers table for each database will conatin this. List of databases is present in sysdatabases Rgds Preetinder "M.J.R." wrote: > I want to be able to retrieve user table privileges > via sql for particular databases (for web page > display) and I assume that somewhere within the > sysmaster schema this data exists. I am, however, > having great difficulties in figuring out how to get > at this data. Does anyone know what table(s) to look > in and what flag(s), if any, are needed? > > As always, TIA! > Marty > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > sending to informix-list sending to informix-list