DROP USER PPSNEPL_READ_ONLY CASCADE;

CREATE USER PPSNEPL_READ_ONLY
  IDENTIFIED BY PPSNEPL_READ_ONLY123
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 3 Roles for PPSNEPL_READ_ONLY 
  GRANT CONNECT TO PPSNEPL_READ_ONLY;
  GRANT PPSNEPL_READ_ONLY_ROLE TO PPSNEPL_READ_ONLY;
  GRANT FDB_DIF_READ_ONLY_ROLE TO PPSNEPL_READ_ONLY;
  ALTER USER PPSNEPL_READ_ONLY DEFAULT ROLE ALL;
  -- 1 Tablespace Quota for PPSNEPL_READ_ONLY 
  ALTER USER PPSNEPL_READ_ONLY QUOTA UNLIMITED ON USERS;
