Create users and roles

To be able to run M3BE certain users, roles and schema must be created. Use these commands for creating the roles and users.

Create users and roles

  1. Create:
    $ export ORACLE_SID=<your SID>
    $ sqlplus /nolog
  2. To connect:
    SQL>connect / as sysdba
  3. Copy and paste these lines to create a file called cre_user_roles.sql on your database server, depending on your Oracle version:
    • For Oracle 11g:

      REM *****************CREATE ROLES ******************
      REM
      REM  Create roles
      REM
      REM
      REM  Role - MDBADMS
      REM ************************************************
      
      CREATE ROLE MDBADMS  NOT IDENTIFIED;
      GRANT CONNECT TO MDBADMS;
      GRANT DBA TO MDBADMS;
      GRANT RESOURCE TO MDBADMS;
      
      REM  Role - MDBUSERS
      REM ************************************************
      
      CREATE ROLE MDBUSERS  NOT IDENTIFIED;
      GRANT ALTER ANY INDEX TO MDBUSERS;
      GRANT ALTER ANY TABLE TO MDBUSERS;
      GRANT ANALYZE ANY TO MDBUSERS;
      GRANT CREATE ANY INDEX TO MDBUSERS;
      GRANT CREATE ANY TABLE TO MDBUSERS;
      GRANT DELETE ANY TABLE TO MDBUSERS;
      GRANT DROP ANY INDEX TO MDBUSERS;
      GRANT DROP ANY TABLE TO MDBUSERS;
      GRANT INSERT ANY TABLE TO MDBUSERS;
      GRANT SELECT ANY TABLE TO MDBUSERS;
      GRANT UPDATE ANY TABLE TO MDBUSERS;
      GRANT CREATE ANY VIEW TO MDBUSERS;
      GRANT DROP ANY VIEW TO MDBUSERS;
      GRANT CONNECT TO MDBUSERS;
      GRANT RESOURCE TO MDBUSERS;
      
      REM  Role - MDBREADS
      REM ************************************************
      
      CREATE ROLE MDBREADS  NOT IDENTIFIED;
      GRANT SELECT ANY TABLE TO MDBREADS;
      GRANT CONNECT TO MDBREADS;
      
      
      REM *****************CREATE USERS ******************
      REM
      REM  Create user account for M3
      REM
      REM
      REM ************************************************
      
      
      create user mdbusr
              identified by MDBUSR
              default tablespace TMVXTEMP
              temporary tablespace TEMP
              quota unlimited on TMVXSD
              quota unlimited on TMVXSI
              quota unlimited on TMVXLD
              quota unlimited on TMVXLI
              quota unlimited on TMVXARCH
              quota unlimited on TMVXTEMP
              quota unlimited on TMVXRUNT
              quota unlimited on USERS;
      GRANT MDBUSERS TO mdbusr;
      
      REM
      REM  Create user with read privs on any table
      REM
      REM
      
      create user mdbread
             identified by MDBREAD
             default tablespace TMVXTEMP
             temporary tablespace TEMP;
      GRANT MDBREADS TO mdbread;
      
      REM
      REM  Create ADMIN user
      REM
      REM
      
      create user mdbadm
             identified by MDBADM
             default tablespace TMVXTEMP
             temporary tablespace TEMP;
      GRANT MDBADMS TO mdbadm;
      
      REM
      REM  Create filing user MVXARCH
      REM
      REM
      
      create user MVXARCH
             identified by MVXARCH
             default tablespace TMVXARCH
             temporary tablespace TEMP;
      grant resource to MVXARCH identified by MVXARCH;
      
      REM
      REM  Grant privs for field audit trail
      REM
      
      grant resource to FATJDTA identified by FATJDTA;
      alter user FATJDTA temporary tablespace TEMP;
      alter user FATJDTA default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to FATJDTA;
      
      -- ----------------------------------------------------------------------------------
      -- Grant system privileges to the role MDBUSERS
      -- ----------------------------------------------------------------------------------
      GRANT CREATE ANY TRIGGER TO "MDBUSERS";
      GRANT CREATE ANY SEQUENCE TO "MDBUSERS";
      GRANT DROP ANY SEQUENCE TO "MDBUSERS";
      GRANT DROP ANY TRIGGER TO "MDBUSERS";
      GRANT ALTER ANY TRIGGER TO "MDBUSERS";
      grant resource to MVXJDTA identified by MVXJDTA;
      alter user MVXJDTA temporary tablespace TEMP;
      alter user MVXJDTA default tablespace TMVXSD;
      grant SELECT ANY TABLE to MVXJDTA;
      grant INSERT ANY TABLE to MVXJDTA;
      grant resource to CUSJDTA identified by CUSJDTA;
      alter user CUSJDTA temporary tablespace TEMP;
      alter user CUSJDTA default tablespace TMVXSD;
      grant SELECT ANY TABLE to CUSJDTA;
      grant INSERT ANY TABLE to CUSJDTA;
      grant resource to FATJDTA identified by FATJDTA;
      alter user FATJDTA temporary tablespace TEMP;
      alter user FATJDTA default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to FATJDTA;
      grant INSERT ANY TABLE to FATJDTA;
      grant resource to MRPSIM01 identified by MRPSIM01;
      alter user MRPSIM01 temporary tablespace TEMP;
      alter user MRPSIM01 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM01;
      grant resource to MRPSIM02 identified by MRPSIM02;
      alter user MRPSIM02 temporary tablespace TEMP;
      alter user MRPSIM02 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM02;
      grant resource to MRPSIM03 identified by MRPSIM03;
      alter user MRPSIM03 temporary tablespace TEMP;
      alter user MRPSIM03 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM03;
      grant resource to MRPSIM04 identified by MRPSIM04;
      alter user MRPSIM04 temporary tablespace TEMP;
      alter user MRPSIM04 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM04;
      grant resource to MRPSIM05 identified by MRPSIM05;
      alter user MRPSIM05 temporary tablespace TEMP;
      alter user MRPSIM05 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM05;
      grant resource to MRPSIM06 identified by MRPSIM06;
      alter user MRPSIM06 temporary tablespace TEMP;
      alter user MRPSIM06 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM06;
      grant resource to MRPSIM07 identified by MRPSIM07;
      alter user MRPSIM07 temporary tablespace TEMP;
      alter user MRPSIM07 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM07;
      grant resource to MRPSIM09 identified by MRPSIM09;
      alter user MRPSIM09 temporary tablespace TEMP;
      alter user MRPSIM09 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM09;
      grant resource to MRPSIM10 identified by MRPSIM10;
      alter user MRPSIM10 temporary tablespace TEMP;
      alter user MRPSIM10 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM10;
      grant resource to MRPSIM11 identified by MRPSIM11;
      alter user MRPSIM11 temporary tablespace TEMP;
      alter user MRPSIM11 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM11;
      grant resource to MRPSIM12 identified by MRPSIM12;
      alter user MRPSIM12 temporary tablespace TEMP;
      alter user MRPSIM12 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM12;
      grant resource to MRPSIM13 identified by MRPSIM13;
      alter user MRPSIM13 temporary tablespace TEMP;
      alter user MRPSIM13 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM13;
      grant resource to MRPSIM14 identified by MRPSIM14;
      alter user MRPSIM14 temporary tablespace TEMP;
      alter user MRPSIM14 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM14;
      grant resource to MRPSIM15 identified by MRPSIM15;
      alter user MRPSIM15 temporary tablespace TEMP;
      alter user MRPSIM15 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM15;
      grant resource to MRPSIM16 identified by MRPSIM16;
      alter user MRPSIM16 temporary tablespace TEMP;
      alter user MRPSIM16 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM16;
      grant resource to MRPSIM17 identified by MRPSIM17;
      alter user MRPSIM17 temporary tablespace TEMP;
      alter user MRPSIM17 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM17;
      grant resource to MRPSIM18 identified by MRPSIM18;
      alter user MRPSIM18 temporary tablespace TEMP;
      alter user MRPSIM18 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM18;
      grant resource to MRPSIM1 identified by MRPSIM1;
      alter user MRPSIM1 temporary tablespace TEMP;
      alter user MRPSIM1 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM1;
      grant resource to MRPSIM20 identified by MRPSIM20;
      alter user MRPSIM20 temporary tablespace TEMP;
      alter user MRPSIM20 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM20;
      
      
    • For Oracle 12c:

      REM *****************CREATE ROLES ******************
      REM
      REM Create roles
      REM
      REM
      REM Role - MDBADMS
      REM ************************************************
      CREATE ROLE MDBADMS NOT IDENTIFIED;
      GRANT CONNECT TO MDBADMS;
      GRANT DBA TO MDBADMS;
      GRANT RESOURCE TO MDBADMS;
      REM Role - MDBUSERS
      REM ************************************************
      CREATE ROLE MDBUSERS NOT IDENTIFIED;
      GRANT ALTER ANY INDEX TO MDBUSERS;
      GRANT ALTER ANY TABLE TO MDBUSERS;
      GRANT ANALYZE ANY TO MDBUSERS;
      GRANT CREATE ANY INDEX TO MDBUSERS;
      GRANT CREATE ANY TABLE TO MDBUSERS;
      GRANT DELETE ANY TABLE TO MDBUSERS;
      GRANT DROP ANY INDEX TO MDBUSERS;
      GRANT DROP ANY TABLE TO MDBUSERS;
      GRANT INSERT ANY TABLE TO MDBUSERS;
      GRANT SELECT ANY TABLE TO MDBUSERS;
      GRANT UPDATE ANY TABLE TO MDBUSERS;
      GRANT CREATE ANY VIEW TO MDBUSERS;
      GRANT DROP ANY VIEW TO MDBUSERS;
      GRANT CONNECT TO MDBUSERS;
      GRANT RESOURCE TO MDBUSERS;
      REM Role - MDBREADS
      REM ************************************************
      CREATE ROLE MDBREADS NOT IDENTIFIED;
      GRANT SELECT ANY TABLE TO MDBREADS;
      GRANT CONNECT TO MDBREADS;
      REM *****************CREATE USERS ******************
      REM
      REM Create user account for M3
      REM
      REM
      REM ************************************************
      create user mdbusr
      identified by MDBUSR
      default tablespace TMVXTEMP
      temporary tablespace TEMP     
      
      
      quota unlimited on TMVXSD
      quota unlimited on TMVXSI
      quota unlimited on TMVXLD
      quota unlimited on TMVXLI
      quota unlimited on TMVXARCH
      quota unlimited on TMVXTEMP
      quota unlimited on TMVXRUNT
      quota unlimited on USERS;
      GRANT MDBUSERS TO mdbusr;
      REM
      REM Create user with read privs on any table
      REM
      REM
      create user mdbread
      identified by MDBREAD
      default tablespace TMVXTEMP
      temporary tablespace TEMP;
      GRANT MDBREADS TO mdbread;
      REM
      REM Create ADMIN user
      REM
      REM
      create user mdbadm
      identified by MDBADM
      default tablespace TMVXTEMP
      temporary tablespace TEMP;
      GRANT MDBADMS TO mdbadm;
      REM
      REM Create filing user MVXARCH
      REM
      REM
      create user MVXARCH
      identified by MVXARCH
      default tablespace TMVXARCH
      temporary tablespace TEMP;
      grant resource to MVXARCH identified by MVXARCH;
      REM
      REM Grant privs for field audit trail
      REM
      grant resource to FATJDTA identified by FATJDTA;
      alter user FATJDTA temporary tablespace TEMP;
      alter user FATJDTA default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to FATJDTA;
      
      -- ----------------------------------------------------------------------------------
      -- Grant system privileges and set temp and deafult ts for users
      -- ----------------------------------------------------------------------------------
      grant resource to CUSJDTA identified by CUSJDTA;
      alter user CUSJDTA temporary tablespace TEMP;
      alter user CUSJDTA default tablespace TMVXSD;
      grant SELECT ANY TABLE to CUSJDTA;
      grant INSERT ANY TABLE to CUSJDTA;
      alter user CUSJDTA QUOTA UNLIMITED ON TMVXARCH;
      alter user CUSJDTA QUOTA UNLIMITED ON TMVXRUNT;
      alter user CUSJDTA QUOTA UNLIMITED ON TMVXTEMP;
      alter user CUSJDTA QUOTA UNLIMITED ON TMVXLD;
      alter user CUSJDTA QUOTA UNLIMITED ON TMVXLI;
      alter user CUSJDTA QUOTA UNLIMITED ON TMVXSD;
      alter user CUSJDTA QUOTA UNLIMITED ON TMVXSI;
      alter user CUSJDTA QUOTA UNLIMITED ON USERS;
      grant resource to FATJDTA identified by FATJDTA;
      alter user FATJDTA temporary tablespace TEMP;
      alter user FATJDTA default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to FATJDTA;
      grant INSERT ANY TABLE to FATJDTA;
      alter user FATJDTA QUOTA UNLIMITED ON TMVXARCH;
      alter user FATJDTA QUOTA UNLIMITED ON TMVXRUNT;
      alter user FATJDTA QUOTA UNLIMITED ON TMVXTEMP;
      alter user FATJDTA QUOTA UNLIMITED ON TMVXLD;
      alter user FATJDTA QUOTA UNLIMITED ON TMVXLI;
      alter user FATJDTA QUOTA UNLIMITED ON TMVXSD;
      alter user FATJDTA QUOTA UNLIMITED ON TMVXSI;
      alter user FATJDTA QUOTA UNLIMITED ON USERS;
      grant resource to HUMJDTA identified by HUMJDTA;
      alter user HUMJDTA temporary tablespace TEMP;
      alter user HUMJDTA default tablespace TMVXSD;
      grant SELECT ANY TABLE to HUMJDTA;
      grant INSERT ANY TABLE to HUMJDTA;
      alter user HUMJDTA QUOTA UNLIMITED ON TMVXARCH;
      alter user HUMJDTA QUOTA UNLIMITED ON TMVXRUNT;
      alter user HUMJDTA QUOTA UNLIMITED ON TMVXTEMP;
      alter user HUMJDTA QUOTA UNLIMITED ON TMVXLD;
      alter user HUMJDTA QUOTA UNLIMITED ON TMVXLI;
      alter user HUMJDTA QUOTA UNLIMITED ON TMVXSD;
      alter user HUMJDTA QUOTA UNLIMITED ON TMVXSI;
      alter user HUMJDTA QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM01 identified by MRPSIM01;
      alter user MRPSIM01 temporary tablespace TEMP;
      alter user MRPSIM01 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM01;
      grant INSERT ANY TABLE to MRPSIM01;
      alter user MRPSIM01 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM01 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM01 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM01 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM01 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM01 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM01 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM01 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM02 identified by MRPSIM02;
      alter user MRPSIM02 temporary tablespace TEMP;
      alter user MRPSIM02 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM02;
      grant INSERT ANY TABLE to MRPSIM02;
      alter user MRPSIM02 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM02 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM02 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM02 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM02 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM02 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM02 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM02 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM03 identified by MRPSIM03;
      alter user MRPSIM03 temporary tablespace TEMP;
      alter user MRPSIM03 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM03;
      grant INSERT ANY TABLE to MRPSIM03;
      alter user MRPSIM03 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM03 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM03 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM03 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM03 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM03 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM03 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM03 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM04 identified by MRPSIM04;
      alter user MRPSIM04 temporary tablespace TEMP;
      alter user MRPSIM04 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM04;
      grant INSERT ANY TABLE to MRPSIM04;
      alter user MRPSIM04 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM04 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM04 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM04 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM04 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM04 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM04 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM04 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM05 identified by MRPSIM05;
      alter user MRPSIM05 temporary tablespace TEMP;
      alter user MRPSIM05 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM05;
      grant INSERT ANY TABLE to MRPSIM05;
      alter user MRPSIM05 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM05 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM05 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM05 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM05 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM05 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM05 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM05 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM06 identified by MRPSIM06;
      alter user MRPSIM06 temporary tablespace TEMP;
      alter user MRPSIM06 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM06;
      grant INSERT ANY TABLE to MRPSIM06;
      alter user MRPSIM06 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM06 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM06 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM06 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM06 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM06 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM06 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM06 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM07 identified by MRPSIM07;
      alter user MRPSIM07 temporary tablespace TEMP;
      alter user MRPSIM07 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM07;
      grant INSERT ANY TABLE to MRPSIM07;
      alter user MRPSIM07 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM07 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM07 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM07 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM07 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM07 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM07 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM07 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM09 identified by MRPSIM09;
      alter user MRPSIM09 temporary tablespace TEMP;
      alter user MRPSIM09 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM09;
      grant INSERT ANY TABLE to MRPSIM09;
      alter user MRPSIM09 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM09 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM09 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM09 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM09 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM09 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM09 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM09 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM10 identified by MRPSIM10;
      alter user MRPSIM10 temporary tablespace TEMP;
      alter user MRPSIM10 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM10;
      grant INSERT ANY TABLE to MRPSIM10;
      alter user MRPSIM10 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM10 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM10 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM10 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM10 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM10 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM10 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM10 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM11 identified by MRPSIM11;
      alter user MRPSIM11 temporary tablespace TEMP;
      alter user MRPSIM11 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM11;
      grant INSERT ANY TABLE to MRPSIM11;
      alter user MRPSIM11 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM11 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM11 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM11 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM11 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM11 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM11 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM11 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM12 identified by MRPSIM12;
      alter user MRPSIM12 temporary tablespace TEMP;
      alter user MRPSIM12 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM12;
      grant INSERT ANY TABLE to MRPSIM12;
      alter user MRPSIM12 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM12 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM12 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM12 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM12 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM12 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM12 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM12 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM13 identified by MRPSIM13;
      alter user MRPSIM13 temporary tablespace TEMP;
      alter user MRPSIM13 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM13;
      grant INSERT ANY TABLE to MRPSIM13;
      alter user MRPSIM13 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM13 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM13 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM13 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM13 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM13 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM13 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM13 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM14 identified by MRPSIM14;
      alter user MRPSIM14 temporary tablespace TEMP;
      alter user MRPSIM14 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM14;
      grant INSERT ANY TABLE to MRPSIM14;
      alter user MRPSIM14 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM14 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM14 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM14 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM14 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM14 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM14 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM14 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM15 identified by MRPSIM15;
      alter user MRPSIM15 temporary tablespace TEMP;
      alter user MRPSIM15 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM15;
      grant INSERT ANY TABLE to MRPSIM15;
      alter user MRPSIM15 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM15 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM15 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM15 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM15 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM15 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM15 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM15 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM16 identified by MRPSIM16;
      alter user MRPSIM16 temporary tablespace TEMP;
      alter user MRPSIM16 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM16;
      grant INSERT ANY TABLE to MRPSIM16;
      alter user MRPSIM16 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM16 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM16 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM16 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM16 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM16 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM16 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM16 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM17 identified by MRPSIM17;
      alter user MRPSIM17 temporary tablespace TEMP;
      alter user MRPSIM17 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM17;
      grant INSERT ANY TABLE to MRPSIM17;
      alter user MRPSIM17 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM17 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM17 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM17 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM17 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM17 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM17 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM17 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM18 identified by MRPSIM18;
      alter user MRPSIM18 temporary tablespace TEMP;
      alter user MRPSIM18 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM18;
      grant INSERT ANY TABLE to MRPSIM18;
      alter user MRPSIM18 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM18 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM18 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM18 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM18 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM18 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM18 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM18 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM19 identified by MRPSIM19;
      alter user MRPSIM19 temporary tablespace TEMP;
      alter user MRPSIM19 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM19;
      grant INSERT ANY TABLE to MRPSIM19;
      alter user MRPSIM19 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM19 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM19 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM19 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM19 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM19 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM19 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM19 QUOTA UNLIMITED ON USERS;
      grant resource to MRPSIM20 identified by MRPSIM20;
      alter user MRPSIM20 temporary tablespace TEMP;
      alter user MRPSIM20 default tablespace TMVXRUNT;
      grant SELECT ANY TABLE to MRPSIM20;
      grant INSERT ANY TABLE to MRPSIM20;
      alter user MRPSIM20 QUOTA UNLIMITED ON TMVXARCH;
      alter user MRPSIM20 QUOTA UNLIMITED ON TMVXRUNT;
      alter user MRPSIM20 QUOTA UNLIMITED ON TMVXTEMP;
      alter user MRPSIM20 QUOTA UNLIMITED ON TMVXLD;
      alter user MRPSIM20 QUOTA UNLIMITED ON TMVXLI;
      alter user MRPSIM20 QUOTA UNLIMITED ON TMVXSD;
      alter user MRPSIM20 QUOTA UNLIMITED ON TMVXSI;
      alter user MRPSIM20 QUOTA UNLIMITED ON USERS;
      grant resource to MVXJDTA identified by MVXJDTA;
      alter user MVXJDTA temporary tablespace TEMP;
      alter user MVXJDTA default tablespace TMVXSD;
      grant SELECT ANY TABLE to MVXJDTA;
      grant INSERT ANY TABLE to MVXJDTA;
      alter user MVXJDTA QUOTA UNLIMITED ON TMVXARCH;
      alter user MVXJDTA QUOTA UNLIMITED ON TMVXRUNT;
      alter user MVXJDTA QUOTA UNLIMITED ON TMVXTEMP;
      alter user MVXJDTA QUOTA UNLIMITED ON TMVXLD;
      alter user MVXJDTA QUOTA UNLIMITED ON TMVXLI;
      alter user MVXJDTA QUOTA UNLIMITED ON TMVXSD;
      alter user MVXJDTA QUOTA UNLIMITED ON TMVXSI;
      alter user MVXJDTA QUOTA UNLIMITED ON USERS;
      
      
  4. Run the new file to create users and groups.
    SQL>@cre_user_roles.sql