Re: Retrieving user privileges via sql

Posted in 2003

malcolm.iiug — Thu, 14 Aug 2003 10:47:10 +0100 — source: Usenet: comp.databases.informix

WRONG! Sysusers contains database level privileges. For table level privileges you need to look at systabauth, syscolauth for the database concerned. Malcolm ----- Original Message ----- From: "preetinder dhaliwal" <preetinder.dhaliwal@dhl.com> To: "M.J.R." <doomdogak@yahoo.com> Cc: "informix user group" <informix-list@iiug.org> Sent: Wednesday, August 13, 2003 11:55 PM Subject: Re: Retrieving user privileges via sql > 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 sending to informix-list