ACCEPT pv_newuser PROMPT 'Enter the new user ID: '

CREATE USER &pv_newuser IDENTIFIED by values 'impossible'
         DEFAULT TABLESPACE USERS
         TEMPORARY TABLESPACE TEMP
         QUOTA 100M on users
         QUOTA 100M on temp;
         GRANT Connect TO &pv_newuser;
         GRANT Resource TO &pv_newuser;
Commit;