Re: Database security

Path: emory!swrinde!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!ucbvax!hplabs!pyramid!infmx!aland From: aland@informix.com (Colonel Panic) Newsgroups: comp.databases.informix Message-ID: <1991Oct12.234253.11010@informix.com> Date: 12 Oct 91 23:42:53 GMT References: <6170@jethro.Corp.Sun.COM> <751@octelb.octel.UUCP> Sender: news@informix.com (Usenet News) Organization: International Brotherhood of Geeks, Local 619 In article <751@octelb.octel.UUCP> richard@octel.UUCP (Richard Karasik) 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. > >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 ;-)) I don't understand that answer at all. Actually, there are two alternatives: 1) have those users use SE as their engine and just create databases in the file system (assuming you have or a re willing to buy SE), or 2) set up a separate OnLine instance for those users. For the latter, you do *not* need an additional license. Users who want to use the "test" instance of OnLine just need to set TBCONFIG appropriately, or have it set for them in their login scripts. >|UUCP richard@octel.com -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "I must have gone through 20 Porsches in the last 15 years. Now I own a Ferrari Testarossa. My body would reject a Plymouth." --Willie Brown, speaker of the California State Assembly