Go Back

User login

Frontpage Sponsor


Google search

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

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;

No votes yet

All times are GMT +2. The time now is 03:18.

©2001-2017 - -