hirosumee

create database warehouse;
go;
use warehouse;
drop table if exists fact_sale_tbl;
drop table if exists time_tbl;
drop table if exists customer_tbl;
drop table if exists store_tbl;
drop table if exists stored_merchan_tbl;
drop table if exists merchandise_tbl;
go;

hirosumee

CREATE USER user001 IDENTIFIED BY password001;
GRANT CONNECT TO user001;
GRANT CONNECT, RESOURCE, DBA TO user001;
-- GRANT CREATE SESSION GRANT ANY PRIVILEGE TO user001;
GRANT UNLIMITED TABLESPACE TO user001;
GRANT CREATE SESSION TO user001;
GRANT CREATE TABLE TO user001;
GRANT CREATE VIEW TO user001;