Oracleでデータベースを設定

$ sqlplus 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;