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

You don't really access the Informix database using a login and password. The way in which Informix security works is by giving privilages to users using the GRANT command ( found in Informix documentation ). GRANT DBA TO JOE grants full DBA privilages whereas GRANT INSERT ON tablename TO JOE allows JOE to insert data to the table tablename JOE MUST exist as a known user on the system i.e. must have a login name and password. If you have any other problems, give me a call. Sean Khanh K Mai <kmai@vertex.com> wrote in article <36543E6C.2BC7621@vertex.com>... > 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 > > Thank you very much for your help > > kmai > >