Create OWB Workspace Owner and Users using Repository Assistant

Follow these steps to create the OWB Workspace Owner and Users using the Repository Assistant:

• Ensure the Database User OWBSYS is unlocked and the Password is set using either SQL Developer or Oracle Enterprise Manager.
• Open the Warehouse Repository Assistant which can be found here: Start - All Programs - Oracle_Home - Warehouse Builder - Administration - Repository Assistant

  Step 1: Enter the Host Name, Port Number and Oracle Service Name, which can all be found in your tnsnames.ora file.

  Step 2: Select Manage Warehouse Builder Workspace

  Step 3: Select Create a new Warehouse Builder workspace

  Step 4: Select Create a workspace with a new user as workspace owner

  Step 5: Enter the SYS user name and password

  Step 6: Enter the Workspace Owner's User Name, e.g. ORCL, and Password. Also enter the Workspace Name, e.g. CURAMBI

  Step 7: Enter the OWBSYS user name and password

  Step 8: Accept the defaults or else change the Tablespaces

  Step 9: Accept the default or else change the Language

  Step 10: Create 5 new schemas - CuramST, CuramDW, CuramDM, CuramDMO and CuramBIROLE. These will be created as Schemas on your database so please name them as Project Standards require.

  Review the Summary and click finish to build the Repository and create the Target Schemas on the Database.

• By running database.create.bischemas the CuramBIROLE is dropped, recreated and granted each of the required access rights in areas such as drop, recreate & debug. CuramST, CuramDW, CuramDM & CuramDMO are also dropped, but on recreation they are simply granted access to CuramBIROLE, giving each of them the same level of access.
• The grant.all command, which gets called by database.all, grants table/view permissions to the 5 schemas (see Appendix G)