Create Database Accounts and Role for OBIA

Create the following DB accounts and role SSE_ROLE before the installation and configuration

·         BAW (Business Analytics Warehouse)

·         INFA (Informatica Repository)

·         INFADM (Informatica Domain)

·         DAC (Data Warehouse Administration Console)

Start Oracle SQL Plus and log on as System

Create Database Accounts and Role for OBIA

Execute the following SQL commands:

create user infa identified by infa;

create user infadm identified by infadm;

create user dac identified by dac;

create user baw identified by baw;

create role sse_role;

grant dba, connect, resource to infa, infadm, dac, baw, sse_role;

grant sse_role to infa, infadm, dac, baw;

Create Database Accounts and Role for OBIA