Create New ORACLE Schema

CREATE USER dblive
  IDENTIFIED BY pwd4dblive
  DEFAULT TABLESPACE tbs_perm_01
  TEMPORARY TABLESPACE tbs_temp_01
  QUOTA 20M on tbs_perm_01;
  
  
GRANT create session TO dblive;
GRANT create table TO dblive;
GRANT create view TO dblive;
GRANT create any trigger TO dblive;
GRANT create any procedure TO dblive;
GRANT create sequence TO dblive;
GRANT create synonym TO dblive;