Skip to main content Skip to complementary content

Configuring a database on Oracle

Before you begin

Make sure the database you are using meet the requirements described in Compatible databases.

Procedure

  1. Log in to an existing database.
    sqlplus.exe SYS@<DB-NAME> as SYSDBA
  2. Create a user MM and a database MM with the following privileges.
    -- 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;
    

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!