Re: Prefixed table names

In article <34d87155.1036270220@news.demon.co.uk>, Ian Clark <ian@tubeway-army.demon.co.uk> writes >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'. > peter probably created the database. >Is the output from 'Info', 'Table' perfectly reasonable? Yes. >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? > Yes. Normally do everything as informix and so owner names do not appear above. >BTW, there is no entry for 'informix' in /etc/group or /etc/passwd. Is >this likely to cause me a problem? > Yes. Check the installation guide. You MUST have user infromix and group informix for installation. Some Informix executables are owned by informix and should be group informix. What does ls -l $INFORMIXDIR/bin give? PS Some commands e.g. tbmode/onmode can only be executed by root or informix. Since you do not have a user informix I suspect this is why root was used. >Any views/comments on my query would be most welcome. > >BTW, we're running SE V4, SQL V4, RDS V4. > >Cheers, Ian. >Tedious 'office speak' part 3: "Let's go scuba in the think tank." -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care