Re: Restricting ISQL access to Administrators only

Do not LOCK ISQL, lock down privilages on the tables. USE roles in application code for TABLE update. If someone is SMART enough to issuse the set role command to update the tables in ISQL they will be smart enough to just run "DBACCESS". My security measure is "Do NOT START" lock out at the TOP do it at the level you really want the "lock out/restriction" to occur. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Wed, 19 Jun 1996 DMurray370@aol.com wrote: > I'd like to be able to restrict ISQL INFORMIX 7.12 access to SYSADMINs only. > All the users currently have UPDATE rights on most of the database tables, so > if they find their way into ISQL they can do alot of damage. I'd like to set > something up in their shell profiles that will "take away" the ISQL command. > We're currently running the HPUX9.? Unix version. I believe I might be able > to reassign the ISQL command to executing something else, but I'm not quite > sure how to do it. > > Any help would be greatly appreciated? > > Thanks, > > David Murray > > >