Hi All ,
My trouble is that I created new user in unix and oracle by using SAM and ora8_maint and when new user login to baan I get error message like "NOT AUTHORİZED USER AS" but I gave authorizations to user and converted run time. What is the problem ? .
Secondly , How can I remove user from ORACLE ? I deleted user baan and unix
but I see the user in ora_users file. When I want to create user again , ora8_maint gives me "this user already created" . What can I do for this problem ?

Thanks
Best Regards ,

Hi,

have you run sessions ttdba0110m000 and ttdba0115m000? That's where you connect the baan user to the oracle user.

Delete the user from ora_users and then delete it from ora8_maint. Hope it works.

Viplov

Is your error message "Not authorized to run as user" ?

That means that in "Maintain User Data" the OS User setting doesn't
match with the with the baan user.

For example:
Baan User = dave23
OS User = dave

If i try to log into Baan I'll get "Not authorized.."

To make this work i would have to log into Baan as "dave" and do the following:
-- -set USER=dave23

Or I could simply make sure that my Baan User and OS User are the same.

Good luck!

Dave

Thanks all , that's OK. But how can I remove user from ora_users with ora8_maint tools ? . I deleted user information from ora_users by using VI editor.

ora8_maint6.1 -U gives you the syntax.

Dave

To use the ora8_admin tool you must set your TERM properly first (VT100)

There are a couple of things you can do to get around or solve this error.
1. Edit the Ora_users file. Copy a line in the file and edit it to reflect the new user you are adding.
bsp:bsp:encrypted_password:baan_group
to
new_user:bsp:encrypted_password:baan_group

Check out authorization into Oracle. Make sure the baan_group is in Oracle.
Make sure the new_users is in oracle and has authorizations to connect, and has the role/membership of the baan_group.
Make sure the encypted_password is equal to the password in Oracle.