Informatica PowerCenter Server Installation

create tablespace

SQL> create tablespace bi_etl_tbs datafile '/u01/app/oracle/oradata/oraprod/bi_etl.dbf' size 1G reuse autoextend on;

Tablespace created.

create domain user

SQL> create user bi_domain identified by bi_domain default tablespace bi_etl_tbs;

User created.

SQL> grant connect,resource,dba to bi_domain;

Grant succeeded.

SQL> grant unlimited tablespace to bi_domain;

Grant succeeded.

SQL> grant select any table to bi_domain;

Grant succeeded.

SQL> alter user bi_domain default role all;

User altered.

create resource user

SQL> create user bi_resource identified by bi_resource default tablespace bi_etl_tbs;

User created.

SQL> grant connect,resource,dba to bi_resource;

Grant succeeded.

SQL> grant unlimited tablespace to bi_resource;

Grant succeeded.

SQL> grant select any table to bi_resource;

Grant succeeded.

SQL> grant create any view to bi_resource;

Grant succeeded.

SQL> alter user bi_resource default role all;

User altered.

create analyz user

SQL> create user bi_dataanalyzer identified by bi_dataanalyzer default tablespace bi_etl_tbs;

User created.

SQL> grant connect,resource,dba to bi_dataanalyzer;

Grant succeeded.

SQL> grant unlimited tablespace to bi_dataanalyzer;

Grant succeeded.

SQL> grant select any table to bi_dataanalyzer;

Grant succeeded.

SQL> grant create any view to bi_dataanalyzer;

Grant succeeded.

SQL> alter user bi_dataanalyzer default role all;

User altered.

create metadata user

SQL> create user bi_metadata identified by bi_metadata default tablespace bi_etl_tbs;

User created.

SQL> grant connect,resource,dba to bi_metadata;

Grant succeeded.

SQL> grant unlimited tablespace to bi_metadata;

Grant succeeded.

SQL> grant select any table to bi_metadata;

Grant succeeded.

SQL> grant create any view to bi_metadata;

Grant succeeded.

SQL> alter user bi_metadata default role all;

User altered.