Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

 
Markus Schmitz's blog
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;



All times are GMT +2. The time now is 10:42.


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