Hi.

Created an Oracle Database manually in order to run the BaanIV master cd over an existing instance (9i). I am Working in W2k.

Tested first with a Baan/MSQL instance creating a table in Oracle and the connection is working.

However I think perhaps the grants for the users I created in Oracle are excessive. Can someone give me an advice?

This is what I've done in terms of users/roles in oracle:

create role r_baandb;
grant dba to r_baandb;
create user baan identified by ...;
grant resource to baan;
grant connect to baan;
grant r_baandb to baan;
create user baandb identified by ...;
grant resource to baandb;
grant connect to baandb;
grant r_baandb to baandb;

Hi there,

just skip the "grant dba" and you are doing excactly, what baan is doing.


happy, it worked ...


Markus