Re: Please correct me: Informix security sucks
Posted in 2000
Topics: General Discussion
From: "Greg Starnes" <gstarnes@ep-services.com> > >My problem is that were using Informix for the back-end of a software >package we are selling. Most of the value of this product is in the schema >of the tables. If we set up this package on our clients computer (who will >have root privelidges on the OS), they can go in and steal the layout of >the >tables. Your entire application's value is in the schema? Nothing on the front end? Most applications (SAP, BAAN, JDE, PeopleSoft) *publish* their schemas to make them more open to third party applications. So you seem to be blowing against the wind here. >With Oracle, there is security at the DB level, so we can preset the >privelidges on the tables, so that they cant get into them and rip them off >(ie. take the schema and use it to set up thier own accounting dept (we are >building an accounting package)). Gee, if I'd known it was that easy to write an accounting application, I would have written one ages ago. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
For oracle: exp full=yes rows=no file=schema.dmp will give you the complete schema including spl, triggers, etc so what is so secure about oracle? -- --------------------------------------------------------- Steven Hauser email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011 ---------------------------------------------------------