Oracle Schema Creation

create user pvprod identified by pvprod
 quota unlimited on planview
 default tablespace planview;

grant    create table,
    create view,
    create session,
    create trigger,
    create procedure,
    create type,
    create sequence,
    create materialized view,
    create synonym to pvprod;

grant execute on dbms_lock to pvprod;
grant execute on dbms_job to pvprod;
grant execute on dbms_lob to  pvprod;
grant execute on dbms_utility to pvprod;
grant all on sys.plsql_trace_runnumber to pvprod;
grant select on dba_tab_columns to pvprod;
grant all on sys.plsql_trace_events to pvprod;
grant execute on dbms_output  to pvprod;
grant execute on dbms_stats  to pvprod; 
grant execute on dbms_sql  to pvprod; 
grant execute on dbms_snapshot to pvprod;

create user pvproddm  identified by pvproddm 
 quota unlimited on planview
 default tablespace planview;

grant    create table,
    create view,
    create session,
    create trigger,
    create procedure,
    create type,
    create sequence,
    create materialized view,
    create synonym to pvproddm;

grant execute on dbms_lock to pvproddm;
grant execute on dbms_job to pvproddm;
grant execute on dbms_lob to pvproddm;
grant execute on dbms_utility to pvproddm;
grant all on sys.plsql_trace_runnumber to pvproddm;
grant select on dba_tab_columns to pvproddm;
grant all on sys.plsql_trace_events to pvproddm;
grant execute on dbms_output  to pvproddm;
grant execute on dbms_stats  to pvproddm; 
grant execute on dbms_sql  to pvproddm;
grant execute on dbms_snapshot to pvproddm;

commit;

exit