Initial Oracle Schemas

The earlier section on 'Create OWB Repository and target schema's provides instructions on how to create the initial oracle roles and schemas with the option of renaming them.

The full list of these schemas is primarily set in the file Reporting\build\scripts\initoracleschemas.sql with recommended access granted between them and the Repositories. In order to make further changes other than the naming conventions, i.e. add extra schemas or alter the preset access granted to these schemas then we recommend the following:

• Copy the initoracleschemas.sql file to another location.
• Make the relevant changes/additions required to this new initoracleschemas.sql file
• Open a command prompt from Reporting\components
• Run the command 'database.create.bischemas' using the -D option to point to the updated copy of the initoracleschemas.sql file.

  E.g. >database.create.bischemas -Dschema.createscript=[full path of updated file]\initoracleschemas.sql

  to run the new script.

• Modifications to naming conventions need only be applied in the BIBootstrap.properties file