Hi,

When we convert a baan user to database user the ora_user file is getting overwritten and losing a number of entries. At times the file is made with just the new user and at times some 3 random records. This has started happening offlate. No changes of parameters is made. At times the encrypted password of all the users that are there in ora_users is wrong and login attempts fail. Please advise.

Regards,
Nancy

Hi,

1. There are 2 ways in which a baan db user can be maintained. One thru the baan db session and the other direct by entering thru the file. Gen we stick to one of the methods. Was there a change in the method of entry ? That might lead to some unix level file access issue.

2. Could you send in a snap shot of the dir listing of the directory ? and some sample entry which is giving trouble.

Regards
Max

The ecryption always makes a new encrypt string. You can check this by running encrypt6.x manually.

Do the following to get the system running:
- create a new user e.g. baannew with password baannew

SQL> create user baannew identified by baannew;

- grant resource, connect and r_<gorup> to this new user

SQL> grant connect, resource, r_baandb to baannew;

- connect with his new user and check if it has the right permissions;

SQL> connect baannew/baannew
SQL> select count(*) from baan.ttttxt010000;

- use encrypt6.x to create an encrypted password for this new user:

$ encrypt6.2 baannew

,X77YyYCDU4$,e"{K&hKRfs%*dz@#tdm

use this password in the $BSE/lib/ora/ora_users file to make a link to a Baan user e.g. bsp:

bsp:baannew:,X77YyYCDU4$,e"{K&hKRfs%*dz@#tdm:baandb

Now you can connect to Baan again.

Good luck,
Dick