Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

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 03:05.


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