When creating new users in the system this was the procedure I’ve used to follow

- Create the user in SUN system (using admintool)
- Create the user in Oracle (using enterprise manager) and grant roles “connect, Resource and R_BAAN)
- Create the user in Baan
- Execute the ora8_admin6.1 in $BSE/bin directory and add the user to group

However in this company I recently joined,
when try to add the user to group using ora8_admin6.1 it says incorrect password and doesn’t allow me to add the new user. What could be the reason? :confused:

I can connect to the database via sqlplus using the newely created user name & password. however it doesn't show any of baan tables

Try to logon as that user on UNIX level and probably you have to change the password.

Kind regards,
Dick

Hi Dikkie,

I can logon to the UNIX level as the same user and even to oracle through sqlplus. But there it doesn't show any of tables.

I can connect to the database via sqlplus using the newely created user name & password. however it doesn't show any of baan tables

Check "DEFAULT_TABLESPACE" for this user.

If you connect as e.g. demo/demo to Oracle, that user will not own the tables. Tables belong to a group user. The group is stored in $BSE/lib/ora/ora_groups. If you want to see these tables from user demo you type:

SQL> select table_name
2 from all_tables
3 where owner = 'BAAN'';

Hope this helps,
Dick

Thanks Dick,

Yes, you are correct. The table owner is Baan. now my issue is when I try to add the user to group using ora8_admin6.1 it says incorrect password and doesn’t allow me to add the new user. What could be the problem?

What could be the problem?That is difficult. Try to set ORACLE_HOME and ORACLE_SID in the tabledef instead of the db_resource. Else I recommend to contact support for this. They probably can help you much faster than I can do.

Hope this helps,
Dick