Oracle - Creating initial users for Baan
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?
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;
The Sleeper has Awakened.