Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing >

Granting File Location Privileges to MAP_USER for Oracle Database 11g Release 2

If you are using Oracle Database 11g Release 2, after mapping deployment you must grant the MAP_USER database user permissions to access the file location.

This task is a step in Roadmap for Installing the ETL Module for Oracle Self-Service E-Billing.

To grant file location privileges to MAP_USER

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

   export ORACLE_SID=OLAP_Instance

   SQLPLUS "/ as sysdba"

2. Run the following SQL statements:

   grant read,write on directory DATA_FILES_LOCATION to map_user;

   grant read,write on directory BAD_FILE_LOCATION to map_user;

   grant read,write on directory DISCARD_FILE_LOCATION to map_user;

   grant read,write on directory LOG_FILE_LOCATION to map_user;