We have BaaN IV C4, ORACLE 8.0.5, Windows NT.

I am trying to create a new user 'xyz'.

I created a user 'xyz' in NT. I created a user 'xyz' in Oracle and given grant and Connect permissions.
The I created a user 'xyz' in BaaN and did a convert to run time.
I tried to login as 'xyz' and I got error message 514 and user doesn't have permission.

Then using BaaN RDBMS Admin module

I created a database user 'xyz'with option create user Externally and did a conv. user.
The I linked baan user with database user using ttdba0110m000 and dumped the user.
Now the status is "Created in DB"

Now when I login as user 'xyz' I am getting error "ERROR 506 table does not exist on ttadv002000"
But I am able to connect as user 'baan'
Only with user 'xyz' it is giving problem.

Pls. tell me where it is going wrong.
I never faced any problem in unix environment.
How do you guys create new users in NT env. on Oracle, SQL Server etc?

I have had this once on a Informix platform.

You should check if there are one or two databases.
With informix you see that there are two db's within BaaN. 001 and 002
You should create all users in onde database lets say database 001.

Then convert to runtime.

That solved the problem for me back then.

NT user must be given permission to log on locally. User Baan is probably a member of "administrators" group so has that permission already.

Hi Shrini,

Have you attached the user XYZ to the group?

This may be the reason why the XYZ user is not getting mapped.

Regards

Ritu Saxena

Hi Ritu,

It was due to permission's problems to the user in Oracle.
Problem solved after granting r_baandb role.

Regards,