changing user passwords?

Hi fellow Informix users, Care for more questions? Lets say I have a database called xyz, and a user called joe that is allowed to access it as dba. How can I change the password for joe? And, how do I create a new user and set its password? Lastly, is there a way to change the default listening port once the software has been installed, and if so how? I am using Informix IDS 9.4 on Windows. Thanks all for your patience and help!

Daniel wrote: > Hi fellow Informix users, > > Care for more questions? > > Lets say I have a database called xyz, and a user called joe that is > allowed to access it as dba. > > How can I change the password for joe? At the login prompt? > And, how do I create a new user and set its password? Under Windows user administration? > Lastly, is there a way to change the default listening port once the > software has been installed, and if so how? You edit the services file in (I think) \\winnt\\system32\\drivers\\etc, then make a similar change to your SQLHOSTS in the Informix program group. > I am using Informix IDS 9.4 on Windows. > > Thanks all for your patience and help! Sure, but try to RTFM at some stage. :o) -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche

"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:bvub7u$102r6f$1@ID-64669.news.uni-berlin.de... > Daniel wrote: > > > Hi fellow Informix users, > > > > Care for more questions? > > > > Lets say I have a database called xyz, and a user called joe that is > > allowed to access it as dba. > > > > How can I change the password for joe? > > At the login prompt? > Sure, why not? Uh, how do I get to the login prompt? :) If I could do it with Server Studio that would be great... > > And, how do I create a new user and set its password? > > Under Windows user administration? > Not sure what you mean here. I do not want to create a Windows user account. > > Lastly, is there a way to change the default listening port once the > > software has been installed, and if so how? > > You edit the services file in (I think) \\winnt\\system32\\drivers\\etc, then > make a similar change to your SQLHOSTS in the Informix program group. > > > I am using Informix IDS 9.4 on Windows. > > > > Thanks all for your patience and help! > > Sure, but try to RTFM at some stage. :o) > I don't have a manual as of yet...I'll just ask you or the group. :)

Daniel wrote: > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > news:bvub7u$102r6f$1@ID-64669.news.uni-berlin.de... >> Daniel wrote: >> >> > Hi fellow Informix users, >> > >> > Care for more questions? >> > >> > Lets say I have a database called xyz, and a user called joe that is >> > allowed to access it as dba. >> > >> > How can I change the password for joe? >> >> At the login prompt? > > Sure, why not? Uh, how do I get to the login prompt? :) CTRL-ALT-DEL usually does it for me. > If I could do it with Server Studio that would be great... > >> > And, how do I create a new user and set its password? >> >> Under Windows user administration? > > Not sure what you mean here. I do not want to create a Windows user > account. Yes, you do. Informix doesn't have it's own authentication, it relies on OS authentication. >> > Lastly, is there a way to change the default listening port once the >> > software has been installed, and if so how? >> >> You edit the services file in (I think) \\winnt\\system32\\drivers\\etc, then >> make a similar change to your SQLHOSTS in the Informix program group. >> >> > I am using Informix IDS 9.4 on Windows. >> > >> > Thanks all for your patience and help! >> >> Sure, but try to RTFM at some stage. :o) > > I don't have a manual as of yet...I'll just ask you or the group. :) F*** that for a game of soldiers. http://www-306.ibm.com/software/data/informix/pubs/ - Now you have the manual. -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche

I think this is what I mean. In Server Studio, I opened up a sql editor and pointed it to my database, then entered a command like this: grant dba to someusername grant connect to someusername I guess what I am asking is, what is the syntax for the command to change the password of "someusername"? Also, how to do I create a new user and set its password within this sql editor? Thanks.

Daniel wrote: > > > I guess what I am asking is, what is the syntax for the command to change > the password of "someusername"? > > Also, how to do I create a new user and set its password within this sql > editor? OTC told you - you don't. IDS uses underlying operating system users and passwords - in your case 'doze users. -- Clive

> > > > Under Windows user administration? > > > > Not sure what you mean here. I do not want to create a Windows user account. Whoops, Informix uses the Window user accounts to authenicate against, it does not maintain a separate list of users in the database, no window account = no access for user -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

someusername must exist as a Windows account. If you were on Unix then you could do what you want with a UDR and bit of hassle, but you'd still only create/update an OS level account. Daniel wrote: > > I think this is what I mean. In Server Studio, I opened up a sql editor and > pointed it to my database, then entered a command like this: > > grant dba to someusername> > grant connect to someusername> > I guess what I am asking is, what is the syntax for the command to change > the password of "someusername"? > > Also, how to do I create a new user and set its password within this sql > editor? > > Thanks. -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

When I installed IDS 9.4, it created a user called informix as an account for the Windows OS. Perhaps if I explained what I want to do, it might make more sense. I am trying to connect to the database using JDBC. The problem is, when I use JDBC and use the informix name and password (from the OS), it does not let me connect to it (I get a connection refused message). Thanks all... "Clive Eisen" <clive@serendipita.com> wrote in message news:4022d06c$0$19303$fa0fcedb@lovejoy.zen.co.uk... > Daniel wrote: > > > > > > I guess what I am asking is, what is the syntax for the command to change > > the password of "someusername"? > > > > Also, how to do I create a new user and set its password within this sql > > editor? > > OTC told you - you don't. > > IDS uses underlying operating system users and passwords - in your case > 'doze users. > > -- > Clive >

On Thu, 5 Feb 2004, Daniel wrote: > I think this is what I mean. In Server Studio, I opened up a sql editor and > pointed it to my database, then entered a command like this: > > grant dba to someusername> > grant connect to someusername Right. This is user authorization. You set the user's privileges in the database with SQL statements. > I guess what I am asking is, what is the syntax for the command to change > the password of "someusername"? That's a complete different story, namely user authentication. Informix doesn't do this itself, but relies on the operating system for doing this. Since you are on Windows, use the Windows procedure for changing the password. You cannot do this in SQL or a sql editor. > Also, how to do I create a new user and set its password within this sql > editor? Same here, you don't. Use the Windows procedures to create a new user and set the password. After that you go into your sql editor and use SQL statements to grant that new user privileges in the database. HTH, Richard