Re: Prefixed table names

Ian Clark wrote: > > Hi All, > > I'm getting to grips with some in-house developed software. On > entering SQL and performing 'Info', 'Table' I get presented with a > list of the tables in the database to choose from. > > I notice some tables are prefixed with the name root and some without. > > I produced a dbschema and a quick glance shows me that for those > listed without the root prefix it looks as though they were created by > the user 'peter'. > > Is the output from 'Info', 'Table' perfectly reasonable? Yes. The tables will be prefixed with the owner, unless you are the owner. > Why would 'root' be an owner? Isn't it more usual to be either > 'informix' or some other user name that has been designated the task > of being the DBA? Good question. Ask the person that created them. ;-) > BTW, there is no entry for 'informix' in /etc/group or /etc/passwd. Is > this likely to cause me a problem? Oh yes. It won't work! x-| I'm surprised dbaccess can see the database! > BTW, we're running SE V4, SQL V4, RDS V4. Oh! Unless someone has changed permissions on your database files. In which case anyone can violate database security! :-| Permissions on the .dbs directory should be 770 informix informix, and the .dat and .idx files should be 660 informix informix. If yours just show a number instead of the user or group, then that was the original userid or groupid of informix. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+