Re: How to add a new login user in Informix?

kmai@my-dejanews.com wrote: > > I have gone through the Administrator's Guide of Informix Online > documentation at informix.com web site and still did not get enough > information about how to add a new login user to Informix Database. > > I mean that I would like to know those Informix DBA commands performing > similar Sybase commands like : > > sp_addlogin "joe" , "joe_passwd" > go > use tester_database_name > go > sp_adduser "joe" > go That's because you do not need to. If the user is recognized by the OS Informix will allow that user to connect to the engine. To access any particular database the user needs connect permissions to that database unless the database grants connect privelege to 'public'. You grant connect privelege to a user on a database with: GRANT CONNECT TO 'username'; While connected to the database as the DBA. Art S. Kagel