Hi, I am trying to do the following

[1] create user in windows
[2] create user in Baan
[3] convert to runtime
[4] create database user
[5] convert user
[6] link baan to database user
[7] dump user

However I get stuck at step 5 as I do not know which user/password to use. Our previous IT person has left and has not noted it down anywhere... I think I should be using sys as username but do not know the password. Is there any way I could reset this?

Thank you very much in advance.
Henk

Hello Henk,

you could reset the password by "alter user ... identified by ...". However there might be scripts on your system that use the (unknown) password and they wont work afterwards.
Maybe its bettter to use a workaround until you receive the pasword from your ex-colleague:

open $BSE/lib/ora/ora_users
duplicate a line from this file (copy+paste)
before the first colon (":") insert the username you created in Baan

Regards,

lebowski

Thank you very much for your reply, however I will be unable to get in contact with my ex colleague as we are not allowed to get into contact with him... I have tried the alter user identified by before posting this post but it did not seem to work.

Just create an oracle user and grant them sysdba privleges (or less depending on how oracle savvy you are). then use that username/password to let baan create the user.

NOTHING should be logging on as sys, so you should be safe to change his password. if something fails, then vollia you found out 'another' stupid thing that your unethical ex-sysadmin did.

key note, nothing in baan relies on the sys user so if this instance of oracle is only serving baan you're most likely problems will be in backups or monitoring, etc. easy fixes overall.

Dave