Re: Please correct me: Informix security sucks

Greg Starnes wrote: > > Informix Dynamic Server 9.3 > > Ok, I am a converted oracle dork, so most of my posts start with: I know > Oracle does this. This is bad because i really like Informix (I truely am a > glutton for punishment). > > Oracle has security at the OS and Database level. All I can find from > Informix is that they only have security at the OS level. SO, if you have > root privileges for the OS, you can get into the tables of our product > (which, obviously we dont want to happen). No, root is the LAST user I let into MY databases! :-) > I work in a software development environment. We are creating an accounting > product with a java front end, and an Informix back-end, which will be > installed to a clients server via our Post sales support team. We've worked > long and hard to get the DB model to where it is. If someone can get into > the database from some 3rd party tool (DB access, etc.), they can take our > tables and start an accounting company. I dont want this to happen; i'd > much rather they pay me for my product. is there a way to keep them from > doing this? Lookup the GRANT and REVOKE commands. However, this will not stop the DBA from seeing your table structures. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+