Hi,

I face a problem while i created a new user, the new user unable to login.

I found that on ttdba0115m000, the status still NOT YET CREATED IN DB.

How to solve it? please advice me, thanks.

Hi,
As the status suggests, have you created the user in the Database using Maintain Database Users session and by clicking on Convert Users button subsequently?

sk

yes, I have done created the user in the Database using Maintain Database Users session and by clicking on Convert Users button.

If the user has been created could you double check in Database by logging in to the database using this username? If you cant then try recreating this user again by deleting him from the above session.

sk

Hi guru,

What your means double check in Database by logging in to the database using this username? can you details explain?

I cant recollect how you do that in Oracle as its been ages since i have worked on it.
b.t.w what is the error message you get when you try to log in with this user name?

I am assuming you had taken the following steps in creating user in addition to creating user at the OS level.
a)Create Baan user in Maintain User Data
b) Run Convert User Data to Runtime Data Dictionary for the user
c) Create db user in Maintain Database Users
d) Convert User
e) Maintain Links between Baan & Database User
f) Dump User

Last but not least, is your application and database running on the same server?

sk

yes. is same server

Per Sukesh's earlier suggestion, why don't you try deleting the user from the Maintain Database Users session, then reenter the user and convert the user. Maybe the first time you created the user there was a hiccup in the process.

Vince

it depends of your schema, you can have one database user for each baan user or one database user for all the baan users, and yes you can do everything that vineco said,but at the very end, what you need to do is to make sure that this user is specified in the $BSE/lib/ora/ora_users file if you want you can test just copying the last line of the file and change the username to match the one with the problem.


Regadrs

I cant recollect how you do that in Oracle as its been ages since i have worked on it.
b.t.w what is the error message you get when you try to log in with this user name?

I am assuming you had taken the following steps in creating user in addition to creating user at the OS level.
a)Create Baan user in Maintain User Data
b) Run Convert User Data to Runtime Data Dictionary for the user
c) Create db user in Maintain Database Users
d) Convert User
e) Maintain Links between Baan & Database User
f) Dump User

Last but not least, is your application and database running on the same server?

sk

Hi guru, Thanks you suggestion,
the above (a) to (f) steps is i follow and done before.
in details, when i created new user in Maintain Database Users then convert user, it will appear error message: ttdba0115: Error 1 occured while execute program, ttdbad1102: Error from Database Maintain Program, Bsp -1 29009 login failed; invalid username/ password
And form database user data will found the status is NOT YET CREATED IN DB

after that when did in the Maintain Links between Baan & Database User, after created new user, it is appear error message ttdba01103: not all users are created in database,

regards

it depends of your schema, you can have one database user for each baan user or one database user for all the baan users, and yes you can do everything that vineco said,but at the very end, what you need to do is to make sure that this user is specified in the $BSE/lib/ora/ora_users file if you want you can test just copying the last line of the file and change the username to match the one with the problem.


Regadrs

Thanks your advice!