shah_bs
31st August 2006, 16:37
The intent is to create an environment that can be accessed by users having a role other than r_baan (because of sensitive data). Any software developed in this environment will be brand new, with no derivation from standard baan VRCs.
Here's what I have done so far (with the ORACLE side being handled by the DBA):
- created the software environment (new package, new modules, new VRC, new Package Combination, etc.).
- Maintain Database Definitions:
The 'Parameter' field is as follows:
ORACLE_HOME=/opt/app/oracle/product/9.2,ORACLE_SID=newsid
- Assign Tables to Databases
The ORACLE DBA created the new database and the new role.
Now for the problem description:
If I link up a new user ID that is linked to the newrole (using ora8_maint6.1 and all that magic), and try to log in, the start up menu does not come up at all. There is a fatal error relating to some SELECT but no table names are logged. This is probably because the login process is trying to get to some Company 000 tables that are still in role r_baan, and Company 000 is in a different SID.
Is there a way to make this work?
Here's what I have done so far (with the ORACLE side being handled by the DBA):
- created the software environment (new package, new modules, new VRC, new Package Combination, etc.).
- Maintain Database Definitions:
The 'Parameter' field is as follows:
ORACLE_HOME=/opt/app/oracle/product/9.2,ORACLE_SID=newsid
- Assign Tables to Databases
The ORACLE DBA created the new database and the new role.
Now for the problem description:
If I link up a new user ID that is linked to the newrole (using ora8_maint6.1 and all that magic), and try to log in, the start up menu does not come up at all. There is a fatal error relating to some SELECT but no table names are logged. This is probably because the login process is trying to get to some Company 000 tables that are still in role r_baan, and Company 000 is in a different SID.
Is there a way to make this work?