Hi experts,

I am running LN on Informix 10.

1) my bsp user and all users are able to login to the system.
2) all baan users are linked to database user bsp.


The problem is I want to change my bsp password. So after i go to unix and change bsp password, no user can log into LN. What is the problem and what must i do to get it to work?

I don't think I need to change the database bsp user password because I have done the same for my Baan4 server before. Right?

Thanks and regards,

No cross/double posting please (just trying to help the boardmasters a bit...)

Hello,

I must confess I've never quite understood how this all hangs together and this is what we need to do in our setup but please take a BACKUP of your inf_users file first.

You basically need to change the encrypted password in the inf_users file to the encrypted form of the new OS password. You can do this by running the encrypt command to a text file and doing a replace in the text editor. However some editors work better than others so look out for any characters that your editor might not like.

Hope this makes sense.

Cheers
Neal

You can have different Unix and Database Passwords.

Did you try to use the session ttdba0915m000 where you can change the database password and regenerate the ora_users or inf_users file.

Do you use the system logon for the Database user? If so, if you change the bsp user's password then you have to regenerate the inf_users file whenever you change the password.
I must confess I've never quite understood how this all hangs together and this is what we need to do in our setup but please take a BACKUP of your inf_users file first.
Good idea. By default BaaN tools saves the previous list of users in ora_users.old and regenerates the new list in ora_users.

Hi,

Is there a command to encrypt my password so that i can see the encrypted values and paste them in inf_users?

Thanks and regards,

not if you're on windows.

if you're on unix you can use encrypt6.1

Dave

hi

i am on LN, where do i find encrypt6.2

rgds

in the bin directory.

Dave

I am on LN on AIX.

The encrypt6.2 file is not in $BSE\bin directory.

Any one can tell me where to get this?

Thanks and regards,

Hello Informix experts,

Can someone out there guide me to change the bsp password in informix.

Please start from the top, as I am new in informix.

I know oracle. In oracle, i go to pl/sql and modify user password with a command.

What is the command to do so in informix.

Thanks and regards

As far as I know Informix uses OS user password.