Skip to main content
If you are a Planview customer, sign in to enable additional content.
Planview Customer Success Center

Oracle Schema Creation

Sign in to access this product help article.

 

EXAMPLE SCRIPT 

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