Go Back > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 83

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 23rd June 2003, 12:09
fmorais's Avatar
fmorais fmorais is offline
Senior Member
Join Date: Mar 2002
Location: Portugal
Posts: 164
fmorais is on a distinguished road
Baan: B4c4 - DB: MSSQL, Oracle, Informix, BBase - OS: Windows, AIX
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?

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;
The Sleeper has Awakened.
Reply With Quote
Old 23rd June 2003, 14:53
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
Hi there,

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

happy, it worked ...

Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle Error 911 when creating table mark_h Operating Systems & Databases 2 15th November 2002 16:46
Error installing B4c4 with Oracle 8.1.7 on NT syllepage Tools Administration & Installation 2 22nd July 2002 14:52
auto creating oracle/unix users chadwickh Operating Systems & Databases 6 10th January 2002 21:38

All times are GMT +2. The time now is 00:07.

©2001-2018 - -