Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
19%
200 - 500 GB
28%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 74

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd June 2003, 11: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

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;
__________________
The Sleeper has Awakened.
Reply With Quote
  #2  
Old 23rd June 2003, 13:53
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
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 ...


Markus
Reply With Quote
Sponsored Links
Reply


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 15:46
Error installing B4c4 with Oracle 8.1.7 on NT syllepage Tools Administration & Installation 2 22nd July 2002 13:52
auto creating oracle/unix users chadwickh Operating Systems & Databases 6 10th January 2002 20:38


All times are GMT +2. The time now is 05:39.


©2001-2018 - Baanboard.com - Baanforums.com