Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
What version of Baan have you installed
Baan IV
30%
FP3
3%
FP4
0%
FP5
0%
FP6
2%
FP7
4%
10.2 (incl. 10.2.1)
3%
10.3
7%
10.4
18%
10.5
29%
Other
2%
Total votes: 89

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 15:46.


©2001-2017 - Baanboard.com - Baanforums.com