✍ Kashif M
Trends

Sunday, 16 November 2014


Create Database Accounts and Role for OBIA


By on November 16, 2014

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
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
Create Database Accounts and Role for OBIA




Kashif
mkashu: Create Database Accounts and Role for OBIA
Review : Kashif | Kashif
Update: November 16, 2014 | Rating: 4.5

Comment for "Create Database Accounts and Role for OBIA"

0 comments

Post a Comment

Blog Archive