Can anyone familiar to Informix help to solve this case?
In BaanV in informix database environment, after login to informix you can key-in inf_admin6.1 command to allow creation,editing,deletion of user password for informix. However in LN6.1, this command inf_admin6.1 is not workable anymore.

This editing of user password is important because in LN6.1 in Maintain User, there is a new "Convert SSA ERP user to SSA Database" (e.g. informix).
So in order for a user to use a new password, we must besides changing the Unix password for that user, we also need to change the new password in the INFORMIX thru inf_admin6.1 (BaanV can do but LN6.1 not available?)

Note also that the inf_admin6.1 only availble in Baan because the command do not appear in google search .

Baan 5 and up all of the commands are called X6.2 is there an
inf_admin6.2 - There is a way to change it, it might have just changed
names (such as inf_maint6.2 or something)

Dave

Dave's right and the binaries exist.

Check for these executeables-
[DEV:bsp]/app/lms/lmsq/opt/bse/bin
>ll inf*
-rwxr-xr-x 1 bsp bsp 1458176 Jun 2 16:36 inf_adm6.2
-rwxr-xr-x 1 bsp bsp 1880064 Jun 2 16:36 inf_maint6.2
-rwxr-xr-x 1 bsp bsp 3657728 Jun 2 16:36 inf_srv6.2
[DEV:bsp]/app/lms/lmsq/opt/bse/bin>

Thanks a lot guys, yes i able to see those inf files.

Also I have found the RDBMS Administration > Database Users (ttdba0515m000)and Links Between SSA ERP users and DAtabase(ttdba0510m000) to solve the problem of when users need to change their password. I can change the users password for informix in the ttdba0515m000.However this method is not desirable.

At the User Data (ttaad2500)>Specific>Convert SSA ERP User to Database User (ttdba0915m000),I tick the "use system logon for Database User". It converts but looks like the system logon for database user is not functioning.
What is the system logon for database user means?

what is my objective?
During our previous BaanIV(without Informix database), user get notification while using Baan if their password is say more than 3 months. So I put a session with unix:Shell program type and process: passwd in the menu for them to change their password themselves.
Is there a equivalent informix change password command (like for unix password: passwd)?
Now with Informix database and LN6, the unix password is ok but how am i able to let user change themselves in user Informix password(i.e without calling me to change password for them in the informix)?


Can you please advise ?

Hi guys,
I found a forum on similar case but need to test it out.
http://www.baanboard.com/baanboard/showthread.php?t=1403

Brad,

You can use the session - ttdba0915m000 to do that.

Refer to the screenshot.

My Q - Why should the users change their own database passwords? Did you enable database password aging? If they already have the database access when they know the database password, what is the purpose of trying to implement Role Authorization System/Security/limited access to GTM etc.
I dont see a reason why the users need to know the database passwords, they should not care what is the underlying application database as long as the application sessions are working, unless they are Application Developers or using Datawarehouse reporting tools etc.