informatica 为INFA SERVER准备表空间和用户

     Informatica 支持很多数据库，这里使用的是oracle,安装informatica server之前需要创建表空间和用户，一般创建两个用户，域用户和存储库用户，示例如下：

--创建表空间

create tablespace infa_table datafile 
'F:\INFA_DATA\Oracle\product\11.0.2\oradata\orcl\infa_table.dbf' size 1024M autoextend on next 512M maxsize 10240M;

--以DBA身份登录后创建用户infa_rep
create user infa_rep identified by infa_rep 
default tablespace infa_table 
quota unlimited on infa_table; 

-- grant/revoke role privileges 
grant connect to infa_rep; 
grant resource to infa_rep; 

-- grant/revoke system privileges 
grant alter session to infa_rep; 
grant create procedure to infa_rep; 
grant create sequence to infa_rep; 
grant create session to infa_rep; 
grant create synonym to infa_rep; 
grant create table to infa_rep; 
grant create trigger to infa_rep; 
grant create type to infa_rep; 
grant create view to infa_rep; 
grant create any index to infa_rep; 
grant create any procedure to infa_rep; 
grant create any table to infa_rep; 
grant create any trigger to infa_rep; 
grant create any type to infa_rep; 
grant create database link to infa_rep; 
grant drop any index to infa_rep; 
grant drop any table to infa_rep; 
grant execute on dbms_lock to infa_rep; 
grant execute on dbms_pipe to infa_rep; 
grant insert any table to infa_rep; 
grant query rewrite to infa_rep; 
grant unlimited tablespace to infa_rep; 
grant execute any procedure to infa_rep; 


--以DBA身份登录后创建用户infa_domain
create user infa_domain identified by infa_domain 
default tablespace infa_table 
quota unlimited on infa_table; 

-- grant/revoke role privileges 
grant connect to infa_domain ;
grant resource to infa_domain ;

-- grant/revoke system privileges 
grant alter session to infa_domain; 
grant create procedure to infa_domain; 
grant create sequence to infa_domain;
grant create session to infa_domain;
grant create synonym to infa_domain;
grant create table to infa_domain;
grant create trigger to infa_domain;
grant create type to infa_domain;
grant create view to infa_domain;
grant create any index to infa_domain;
grant create any procedure to infa_domain;
grant create any table to infa_domain;
grant create any trigger to infa_domain;
grant create any type to infa_domain;
grant create database link to infa_domain;
grant drop any index to infa_domain;
grant drop any table to infa_domain;
grant execute on dbms_lock to infa_domain;
grant execute on dbms_pipe to infa_domain;
grant insert any table to infa_domain;
grant query rewrite to infa_domain;
grant unlimited tablespace to infa_domain;
grant execute any procedure to infa_domain;