Oracle

To create a database on an existing Oracle database server, please use this SQL and adjust it to your needs:

-- ---------
-- USU PORTAL
-- ---------

CREATE BIGFILE TABLESPACE usu_portal DATAFILE 'usu_portal.dbf' SIZE 100M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER usu_portal IDENTIFIED BY "password" DEFAULT TABLESPACE usu_portal QUOTA UNLIMITED ON usu_portal;

GRANT CREATE JOB, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE VIEW TO usu_portal;

GRANT SELECT ANY TABLE TO usu_portal;
GRANT INSERT ANY TABLE TO usu_portal;
GRANT UPDATE ANY TABLE TO usu_portal;
GRANT DELETE ANY TABLE TO usu_portal;