Hallo, i have baanV installed on windows on SQL server, i would like to connect another company but on oracle.
So i installed oracle and now i have to configure it for baan, there are some tools for do that?

Thanks
Barbara

I use these statements if I create a new instance:

create role r_baandb;
grant dba to r_baandb;
create user baan identified by xxxx default tablespace baandb
temporary tablespace temp;
create user baandb identified by xxxx default tablespace baandb
temporary tablespace temp;
grant connect to baan;
grant resource to baan;
grant r_baandb to baan;
grant connect to baandb;
grant resource to baandb;
grant r_baandb to baandb;

Probably the 'grant dba' should not be done since each new baan user is given the role r_baandb. Anyway this works for me.

Perhaps other members can tell us how they do this? Grant dba to specific users only?

Regards,
Han

I would never grant dba to any user.
And even the grant resource could be trimmed down to a few grants, but connect and resource are more than enough.