Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing > Process of Installing the Oracle Warehouse Builder Repository >

Granting Rights to MAP_USER

You must grant the MAP_USER database user permissions to use the Oracle Warehouse Builder resources.

This task is a step in Process of Installing the Oracle Warehouse Builder Repository.

You can grant the rights to MAP_USER using either individual grant commands or the grant repository script.

To grant the necessary rights to MAP_USER using individual grant commands

1. Using SQL*Plus, log on to OLAP database as SYSDBA, where OLAP_Instance is the name of the OLAP instance:

   export ORACLE_SID=OLAP_Instance

   SQLPLUS "/ as sysdba"

2. Enter the following commands:

   grant SELECT ANY DICTIONARY to map_user;

   grant SELECT ANY TABLE to map_user;

   grant INSERT ANY TABLE to map_user;

   grant UPDATE ANY TABLE to map_user;

   grant DELETE ANY TABLE to map_user;

   grant EXECUTE ANY PROCEDURE to map_user;

   grant SELECT ANY SEQUENCE to map_user;

   If the repository is created using Oracle Warehouse Builder 10g Release 2, enter:

   grant OWB_O_REP_ADMIN to owf_mgr;

   If the repository is created using Oracle Warehouse Builder 11g, enter:

   grant OWB_USER to owf_mgr;

To grant the necessary rights to MAP_USER using the grant repository script

• Go to the Oracle Self-Service E-Billing database 6.0.3 installation folder EDX_HOME/db/ebilling/oracle/olap/etl/packages (or the EDX_HOME\db\ebilling\oracle\olap\etl\packages folder on Windows), and make sure that the repository_grants.sql file exists in the folder. In the path, EDX_HOME is the location where Oracle Self-Service E-Billing is installed. Then log in to the OLAP database using as sysdba using the following command at the SQL*Plus prompt:

  export ORACLE_SID=OLAP_Instance

  SQLPLUS "/ as sysdba"

  SQL>@repository_grants.sql