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

 
How to create Oracle users/roles manually
By Markus Schmitz at 23 Feb 2008 - 23:44

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 06:07.


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