Database Setup

Create a user MM and a database MM with the following privileges:

sqlplus.exe SYS@<DB-NAME> as SYSDBA
‎  
‎ -- Delete previous user and database if needed
‎ -- DROP USER MM CASCADE;
‎  
‎ CREATE USER MM IDENTIFIED BY MM123!;
‎  
‎ GRANT CONNECT TO MM;
‎  
‎ GRANT CREATE TABLE TO MM;
‎ GRANT CREATE VIEW TO MM;
‎ GRANT CREATE SEQUENCE TO MM;
‎ GRANT CREATE TRIGGER TO MM;
‎ GRANT CREATE PROCEDURE TO MM;
‎ GRANT CREATE TYPE TO MM;
‎  
‎ GRANT EXECUTE ON DBMS_LOB TO MM;
‎  
‎ -- If you get the error "Database exception occurred: ORA-01950: no privileges on tablespace 'USERS'"
‎ -- ALTER USER MM QUOTA UNLIMITED ON USERS;