Baanboard.com

Go Back   Baanboard.com > Blogs > Markus Schmitz's blog

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

 
Creating Oracle roles manually
By Markus Schmitz at 18 Apr 2008 - 16:47

You can create all needed users/roles manually, but you have to keep the same passwords, because you have only one ora_users file for all databases.

 

Here we go:

 

1) You need to create the schema owner. In Unix this is normally baan and in NT often baandb:

create user baan identified by xyz;
grant ressource to baan;
grant connect to baan;

 

2) You need to create the role which all Baan users belong to. In Unix, this is r_baan:

create role r_baan;

 

3) You need to create the actual Oracle users for the Baan users, see ora_users file:

create user heinz identified by XYZ;
grant connect to heinz;
grant ressource to heinz;
grant r_baan to heinz;

0
No votes yet


All times are GMT +2. The time now is 12:54.


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