Re: How to add a new user to Informix Database?

Using recycled bits, Sean Kelsey blurted out: %Sorry Khanh, I have been unable to respond via e-mail - problems at my end %!!! % %To add users on the system, you'll have to go through the UNIX system admin. %Simply add them as part of the informix group. Once they are recognised by %UNIX then you can grant and revoke permissions accordingly. ( I trust this %is a UNIX box ?? ). Only the `informix' user should be a member of the `informix' group. Doing otherwise compromises your data integrity. User of database A can inadvertently modify the contents of database B. The recommended approach is to set the appropriate environment variables for database access in each individual user's .profile (.login, .whatever), or use a global init script that accomplishes the same thing. Of course, you still have to use UNIX utilities to create the user. :) %NT works in a similar way, but you will need to navigate your way around the %security labarynth before users can use the relevant chunks/databases. `NT' and `works' in the same sentence? Hmmm. Kurt -- Kurt Wall Informix on Linux FAQ - http://www.xmission.com/~kwall/iolfaq.html Spanish Translation - http://www.xmission.com/~kwall/iolfaqsp.html