Re: Create informix user with root privilige: How?

In reply to Terry C.W. Lai's email about Create informix user with root priv, on 29 Nov 96 Hi Terry, My 2p worth > 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. > <<Informix Guide quote snipped>> > > 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? > The IDs are ok. No need to change them back to 121. However, if you have some access problem , in the sense , that you have some files with owner 121 instead of informix , then simply use the chown command by logging in as user root. However, if there are many such files , then you can execute the following after you login as root find ./ -user 121 -exec chown informix {} \\; This will find all files with userid 121 and will change owner to informix. > 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? > The statement which means that informix as a user enjoys same kind of privileges within the Informix RDBMS as does root within Unix O.S. For example, root as superuser can create new users , retire old ones etc. Similarly , informix as a user can allow or disallow users from accessing databases. > Pardon me for my ignorance and hope someone could shed some light to > me. Many thanks. Hope this helps, Ravi..... -- Ravi Joseph Pinto, mailto:ravi@in.dhl.com Consultant, Astra Infotech, voice :91-22-8503000 Mumbai, India extn. 1531 Standard disclaimers apply. Off to Frankfurt.