DROP USER PPSNEPL CASCADE
/

CREATE USER PPSNEPL
  IDENTIFIED BY PPSNEPL_123
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP
  PROFILE SERVICE_ACCOUNT
  ACCOUNT UNLOCK
/
  -- 4 Roles for PPSNEPL
  GRANT CONNECT TO PPSNEPL
/
  GRANT RESOURCE TO PPSNEPL
/
  GRANT CREATE SESSION TO PPSNEPL
/
  GRANT SELECT_CATALOG_ROLE TO PPSNEPL
/
  GRANT CREATE VIEW TO PPSNEPL
/

  -- 1 System Privilege for PPSNEPL
  GRANT UNLIMITED TABLESPACE TO PPSNEPL
/
  -- 1 Tablespace Quota for PPSNEPL
  ALTER USER PPSNEPL QUOTA UNLIMITED ON USERS
/
