Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!bloom-beacon!apple!rutgers!rochester!pt.cs.cmu.edu!cadre!pitt!darth!investor!news
From: news@investor.UUCP ( Bob Peirce)
Newsgroups: comp.databases
Subject: Restricting access to Informix tables
Message-ID: <1080@investor.UUCP>
Date: 6 May 89 00:37:17 GMT
Organization: Cookson, Peirce & Co., Pittsburgh, PA
Lines: 14

We have a database we want to keep most people from updating or
inserting except under controlled circumstances; ie, No from sperform,
but YES from a 4GL data entry program.  We thought having the data entry
program suid the database manager would do it but no luck.  Apparently
Informix looks at the real user, not the effective user.

Does anybody have a solution?  We want to keep the current lack of
priviliges and get the permission through the 4GL program somehow.
We do not want to actually change permissions from the 4GL program,
however.
-- 
Bob Peirce, Pittsburgh, PA				 412-471-5320
uucp: ...!{allegra, bellcore, cadre, idis, psuvax1}!pitt!investor!rbp
	    NOTE:  Mail must be < 30K  bytes/message