Re: Database security

Path: emory!samsung!uunet!indetech!vsi1!octel!richard From: richard@octel.UUCP (Richard Karasik) Newsgroups: comp.databases.informix Message-ID: <751@octelb.octel.UUCP> Date: 11 Oct 91 16:37:33 GMT References: <6170@jethro.Corp.Sun.COM> Organization: Octel Communications Inc., Milpitas Ca. In article <6170@jethro.Corp.Sun.COM> myro@srfrogs.Corp.Sun.COM writes: > >In article 503@rand.mel.cocam.oz.au, shaneb@auzodt3.mel.cocam.oz.au (Shane Booth writes: >> >> Does anyone know a way to allow users to run a 4GL application that inserts >> and deletes from a database, but to disallow the users from altering the data >> by running isql? Here we run Informix-4GL version 4.00.UC1 for Sco Unix. > >Informix permissions are kept by the backend not the frontend, thus there is >no way to give access to a user under 4GL and not SQL. What _may_ work is to > ....... I asked Informix about this - Im running on-line. The situation is - Im running a corporate database, and several people want to "learn" SQL using ISQL and set up their own little databases. Informix's official answer to this is to buy another runtime license for on-line, and have two database engines trashing up my 4/490 with runaway processes (Im not sure if the last part of that sentence is offical policy tho ;-)) Im sure ther has to be better ways to do thi ... HALLLPPPPPP! -- |UUCP richard@octel.com |VOICE (408) 942-6372 |