Hi,

I am trying to create a new user in Baan using a new system login code but I keep receiving error "database not on"
Anyone knows why?

My steps are:
1. Create system login
2. Create Baan user and linked it to system login code and convert to runtime
3. Link Baan user to database user and convert to runtime

Thanks a lot

PS: My db is Oracle 9.2

Hi,

You have to create the oracle user to and grant permission to baan. Using encript you also have to add the user info in ora_users.

Regards,
Klaas

Hi Klaas,

Could you tell me the steps to create oracle user and granting the permission and all other steps necessary..

Thanks,
Hendra

Yes, I will appreciate it if someone can give me the steps for
creating a new user in Oracle 9i in Windows platform.

I cannot run ora_maint.exe in Windows platform and the system do not
have ora_admin in Windows. So how do i create the user in Oracle using baan??

thanks and regards

You can use the session "Database users" under Path Tools --> database Management --> RDMBS administration.

This way you do not have to worry about the encrypted password in %BSE%\lib\ora\ora_users file. Baan will take care of it when you convert the user.

hi,

Yes I create a new database user using the Maintain Database user session. The user now is created in Oracle. But I don't see this user in the $BSE/lib/ora/ora_users file. I tried to login but failed with this error 505.

Can someone give me the actual steps to create new user.

Is it??
1) Create user in Windows OS (with password user123)
2) Create user in Baan
3) Convert to runtime dict
4) Create database user (with different password user456)
5) Convert user
6) Link baan user to database user
7) Dump user

I use this steps but cannot log in


thanks and regards,

I use the same steps as you have described on Baan5 system, it works without any problem.

Did the last step "dump users" work without giving any error message?

Yes, there is no errors when following my steps, but when I try to login, I still get error message 505. Furthermore I don't see the user id created in BSE/lib/ora/ora_users file.

regards

Hi,

To convert baan user to database user.

The OS user with the same user name as baan should already exist.
The OS user with the same user name as baan should already exist.

The record with user = user4 is inserted in the session ttdba0515m000 and in the $BSE/lib//<RDBMS>/<RDBMS>_users file. Also the record is inserted in ttdba0510m000 session where database user = user4.


Tables and Files used:

The following tables are used:

1. ttdba200 – User Data
2. ttdba015 – Database Users
3. ttdba010 – Links Between Baan Users and Database Users.

The following files are used:
1.$BSE/lib/<RDBMS>/<RDBMS>_users.

As per Kingsto88's postings..

The OS user with the same user name as baan should already exist.


It is created.

The record with user = user4 is inserted in the session ttdba0515m000 and in the $BSE/lib//<RDBMS>/<RDBMS>_users file. Also the record is inserted in ttdba0510m000 session where database user = user4.

Couldn't quite get what you are suggesting. Does user need to be inputed in $BSE/lib/ora/ora_users file manually? How can the encrypted password be taken care on Windows system?

What do you mean by user = user4 ?

Hi Nandan

You will have to input a record in $BSE/lib/ora/ora_users manually. And encrypetd password of user is saved in etc/shadow. in Unix platform. For Windows baan login is opened through SSPI which is Microsoft Security Support Provider Interface (SSPI) is the well-defined common API for obtaining integrated security services for authentication, message integrity, message privacy, and security quality of service for any distributed application protocol.


Viplov

Wow....hats off..

FYI ...I am talking about Baan encrypted password in %BSE%\lib\ora\ora_users.