Re: Create informix user with root privilige: How?

terrylai@hkstar.com (Terry C.W. Lai) wrote: :Currently, I'm asked to re-install the INFORMIX-Online Version 5.01 on :the other 486 pc running SCO UNIX System V/386 Release 3.2 Version :4.2. :The Informix Installation Guide said that : :1. create a new group called "informix" and its group number should be :greater than or equal to 100 :2. create a new user called "informix" and its user ID number should :be greater than or equal to 100 :3. the user "informix" is the database equivalent of the UNIX "root" :account :The problems are : :1. The newly created group number and the user ID are both equal to :201 (The previous group and user ID numbers are 121). Should I need to :change them from 201 back to 121? If so, then how to do it? There should be only one group informix and one user informix but it shouldn't be possible to create more than one either. What do you mean by "the previous group and user ID"? On the same machine? At some previous time? As long as the user and group informix is created before you start installing Informix everything should be ok. :2. What does it mean the user "informix" is the database equivalent of :the SCO UNIX r3.2 v4.2 "root" account? And how to make this? Only that the user informix has special extended rights to access and modify anything inside any informix based database. You should normaly not log in on your Unix machine as user Informix for anything but special maintenance, backup and similar things. You shouldn't create databases or otherwise modify them when logged in as informix. The user informix automatically have these extended rights if you follow the installation description. You should spesifically not modify the ID numbers after you have created the group and user, and particularly not after you have installed any Informix product. If you do you should expect all kinds of problems. To keep things simple for yourself you create another special user and log in as this user to create your database. This then becomes the database administrator user with all rights on this database. Normally you would only grant connect to other users so they can not create their own tables or otherwise modify the structure of the database. :Pardon me for my ignorance and hope someone could shed some light to :me. Many thanks. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org