Verify Users and Default Tablespaces

Verify Users and Default Tablespaces

  1. Create:
    $ export ORACLE_SID=<your SID>
    $ sqlplus /nolog
  2. To connect:
    SQL>connect / as sysdba
  3. To verify the output:
    SQL> set pages 32
    select USERNAME,DEFAULT_TABLESPACE from dba_users 
    where username like 'MRPSIM%' 
    or username like '%JDTA' 
    or username like 'MDB%' 
    or  username like 'MVX%' order by 1;
    select * from dba_roles where ROLE like 'MDB%';
    
    USERNAME DEFAULT_TABLESPACE
    CUSJDTA TMVXSD
    FATJDTA TMVXRUNT
    MDBADM TMVXTEMP
    MDBREAD TMVXTEMP
    MDBUSR TMVXTEMP
    MRPSIM01 TMVXRUNT
    MRPSIM02 TMVXRUNT
    MRPSIM03 TMVXRUNT
    MRPSIM04 TMVXRUNT
    MRPSIM05 TMVXRUNT
    MRPSIM06 TMVXRUNT
    MRPSIM07 TMVXRUNT
    MRPSIM09 TMVXRUNT
    MRPSIM1 TMVXRUNT
    MRPSIM10 TMVXRUNT
    MRPSIM11 TMVXRUNT
    MRPSIM12 TMVXRUNT
    MRPSIM13 TMVXRUNT
    MRPSIM14 TMVXRUNT
    MRPSIM15 TMVXRUNT
    MRPSIM16 TMVXRUNT
    MRPSIM17 TMVXRUNT
    MRPSIM18 TMVXRUNT
    MRPSIM20 TMVXRUNT
    MVXARCH TMVXARCH
    MVXJDTA TMVXSD
    26 rows selected.
    SQL>
    
    ROLE PASSWORD AUTHENTICAT
    MDBADMS NO NONE
    MDBREADS NO NONE
    MDBUSERS NO NONE