Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!nrl-cmf!ames!ucsd!sdcsvax!ucsdhub!hp-sdd!hplabs!hpl-opus!hpspdra!hpcmsrb!bhave
From: bhave@hpcmsrb.HP.COM (Nitin Bhave)
Newsgroups: comp.databases
Subject: Informix access/permission Question.
Message-ID: <12460001@hpcmsrb.HP.COM>
Date: 31 Jan 89 17:54:48 GMT
Organization: HP Corporate Manufacturing Systems
Lines: 24


I have a question concerning Informix access/permissions.

We require that certain tables in our database be modified only by
a fixed set of 4GL or ESQL/C programs. These programs will be owned by
a single login name and also only this same login name will have insert/update
permission on these tables. But  other users should be able to run
these programs ( or modify the tables via these programs ). In other words
we don't want to give all the users the capability of modifying these tables 
through interactive SQL or through their own programs. Setting the
setuid bit doesn't help because Informix apparently gets the real uid
( rather than the effective uid ) to determine table access.

Is there any way I can implement the above scheme ?

Thanks in advance.

Nitin Bhave
CMS
Hewlett Packard
Palo Alto, CA 94304
(415)857-5772

email: bhave%hpcmsa@hplabs.hp.com