Re: Can we change the password of the informix user?

Posted in 2004

Kanchana Padmanabhan — Fri, 27 Feb 2004 12:07:37 -0600 — source: Usenet: comp.databases.informix

--0__=09BBE4D4DFCC30518f9e8a93df938690918c09BBE4D4DFCC3051 Content-type: multipart/alternative; Boundary="1__=09BBE4D4DFCC30518f9e8a93df938690918c09BBE4D4DFCC3051" --1__=09BBE4D4DFCC30518f9e8a93df938690918c09BBE4D4DFCC3051 Content-type: text/plain; charset=US-ASCII Whenever username & password are supplied in a connection(be it through ODBC or any other connectivity tool), they have to be a valid username-password combination on the server machine. Putting in other words, if a user exists on both client & server machine, and the passwords are different, the server machine password has to be supplied during connection. Side note: A connection can also be made without specifying username & password. In this circumstance, the concept of trusted machine, trusted user or sqlhosts settings come into picture. Regards, Kanchana Padmanabhan Software Engineer R&D - IBM Data Management Group 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 |---------+----------------------------> | | banganae@yahoo.co| | | m.sg (Zizou79 | | | aka Alan) | | | Sent by: | | | owner-informix-li| | | st@iiug.org | | | | | | | | | 02/27/2004 07:54 | | | AM | | | Please respond to| | | banganae | |---------+----------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: informix-list@iiug.org | | cc: | | Subject: Can we change the password of the informix user? | >------------------------------------------------------------------------------------------------------------------------------| My ODBC drivers for Informix are unable to resolve the password for my Informix user 'informix'. This is the default user who is an Win OS-level user. If the change the password of the user does this conflict with the database's ability to authenticate the user? Also can we create users at Win OS level and assign them to either Informix-Admin or IX-USERS? Can these users access the informix server by suplying their OS level passwords? pls help Thanks --1__=09BBE4D4DFCC30518f9e8a93df938690918c09BBE4D4DFCC3051 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> Whenever username & password are supplied in a connection(be it through ODBC or any other connectivity tool), they have to be a valid username-password combination on the server machine. Putting in other words, if a user exists on both client & server machine, and the passwords are different, the server machine password has to be supplied during connection. Side note: A connection can also be made without specifying username & password. In this circumstance, the concept of trusted machine, trusted user or sqlhosts settings come into picture. Regards, Kanchana Padmanabhan Software Engineer R&D - IBM Data Management Group 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 <img src="cid:10__=09BBE4D4DFCC30518f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for banganae@yahoo.com.sg (Zizou79 aka Alan)">banganae@yahoo.com.sg (Zizou79 aka Alan) <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=09BBE4D4DFCC30518f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""> </td><td style="background-image:url(cid:30__=09BBE4D4DFCC30518f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=09BBE4D4DFCC30518f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""> <ul> <ul> <ul> <ul>banganae@yahoo.com.sg (Zizou79 aka Alan) Sent by: owner-informix-list@iiug.org 02/27/2004 07:54 AM Please respond to banganae</ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=09BBE4D4DFCC30518f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""> To: informix-list@iiug.org cc: Subject: Can we change the password of the informix user?</td></tr> </table> <tt>My ODBC drivers for Informix are unable to resolve the password for my Informix user 'informix'. This is the default user who is an Win OS-level user. If the change the password of the user does this conflict with the database's ability to authenticate the user? Also can we create users at Win OS level and assign them to either Informix-Admin or IX-USERS? Can these users access the informix server by suplying their OS level passwords? pls help Thanks </tt> </body></html> --1__=09BBE4D4DFCC30518f9e8a93df938690918c09BBE4D4DFCC3051-- --0__=09BBE4D4DFCC30518f9e8a93df938690918c09BBE4D4DFCC3051 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=09BBE4D4DFCC30518f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=09BBE4D4DFCC30518f9e8a93df938690918c09BBE4D4DFCC3051 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=09BBE4D4DFCC30518f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=09BBE4D4DFCC30518f9e8a93df938690918c09BBE4D4DFCC3051 Content-type: image/gif; name="pic23998.gif" Content-Disposition: inline; filename="pic23998.gif" Content-ID: <30__=09BBE4D4DFCC30518f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 @@NL@