REM -------------------------------------------------------------------------
REM Create Chordiant FS default roles and users with necessary privileges
REM -------------------------------------------------------------------------
REM

create role r_ccsown;
grant connect, resource, create view to r_ccsown;

create role r_ccsusr;
grant create session, create table, create synonym to r_ccsusr;

create user ccsowner
identified by ferrari
default tablespace dev
temporary tablespace temp
quota unlimited on dev
quota unlimited on idx;

grant r_ccsown to ccsowner;

create user pduser
identified by mappings
default tablespace sbox
temporary tablespace temp
quota unlimited on sbox
quota 0 on dev
quota 0 on idx;
grant r_ccsusr to pduser;


REM -------------------------------------------------------------------------
REM Create Sky Roles and Users
REM -------------------------------------------------------------------------
REM

create role r_skyown;
grant connect, resource, create session, create table, create synonym, create view to r_skyown;

create role r_skyrefdatamgr;
grant connect, resource, create session, create table, create synonym, create view to r_skyrefdatamgr;

create role r_skytools;
grant connect, resource, create session, create table, create synonym, create view to r_skytools;


create user skyowner
identified by skyowner
default tablespace dev
temporary tablespace temp
quota unlimited on dev
quota unlimited on idx;

grant r_skyown to skyowner;

create user refdatamgr
identified by refdatamgr
default tablespace dev
temporary tablespace temp
quota unlimited on dev
quota unlimited on idx;
grant r_skyrefdatamgr to refdatamgr;


commit;
spool off



