RE: Informix SMI tables

Posted in 2004

Colin Bull — Mon, 29 Nov 2004 08:57:40 -0000 — source: Usenet: comp.databases.informix

Manoharan wrote > I would like to know what user privilege is needed to query > Informix SMI tables. > can any informix user query SMI tables? Pls advise. > select a.* from systabauth a, systables b where a.tabid = b.tabid and tabname = "sysdbspaces" Outputs-- sysmaster:sysdbspaces grantor informix grantee public tabid 170 tabauth s-------- So I guess Joe public has select permisssions by default, so as long as they have connect permissions to the database, that is all they need. Colin Bull _______________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. _______________________________________________________________________ sending to informix-list