I have created a second database in Oracle and I would like to create a new company in Baan to access this new database. What I am not sure about is the users roles and privileges required within Oracle for Baan.

Hi there,

you can create all needed users/roles manually, but you have to keep the same passwords, because you have only one ora_users file for all databases.

Here we go:

1) You need to create the schema owner. In Unix this is normally "baan" and in NT often "baandb":

create user baan identified by xyz;
grant ressource to baan;
grant connect to baan;

2) You need to create the role, which all Baan users belong to. In Unix, this is "r_baan":

create role r_baan;

3) You need to create the actual Oracle users for the Baan users, see Ora_users file:

create user heinz identified by XYZ;
grant connect to heinz;
grant ressource to heinz;
grant r_baan to heinz;

You also might want to specify the default and temporary tablespace.

Works for me,

regards

Markus

Thats what I needed