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 ITECSTUDENT TO &pv_newuser;
Insert into pwagent.accounts (OraAccount, RUaccount, initdate) values (upper('&pv_newuser'),lower('&pv_newuser'),sysdate);
Commit;