Interactive Create User script

From: Richelle Hutchinson <rhutchin_at_prodigy.net>
Date: Fri, 25 Aug 2000 16:47:28 -0400
Message-ID: <8o6m1j$407s$1@newssvr05-en0.news.prodigy.com>

I'm trying to come up with a reliable, simple approach to interactively create Oracle accounts on both PO8 and HP Oracle8 databases. Below is my first attempt. As you can see, I'm using two scripts to acheive this. I also hate having the user to remember to 'spool off' but when I programmed it in it didn't work because I'm having them break out of the loop by the use of a Ctrl-C (which sometimes causes a Dr Watson on my PO8 version).

I'm open to suggestions if you have a better approach. Thanks in advance.

---------------------------------------------enter_user.sql
script-----------------------------------------------

clear screen
spool c:\projects\dtl\dbs\enter_user
PROMPT HAVE LIST OF USER ACCOUNTS AVAILABLE BEFORE PROCEEDING pause Press RETURN to continue, Ctrl-C to stop, turn 'spool off' when finished
ACCEPT userid CHAR PROMPT 'User Account: ' ACCEPT pswd CHAR PROMPT 'Password: ' HIDE create user &userid identified by &pswd
default tablespace user_data
temporary tablespace temporary_data;
@c:\projects\dtl\dbs\enter_user2

---------------------------------------------enter_user2.sql
script-----------------------------------------------

ACCEPT userid CHAR PROMPT 'User Account: ' ACCEPT pswd CHAR PROMPT 'Password: ' HIDE create user &userid identified by &pswd
default tablespace user_data
temporary tablespace temporary_data;
@c:\projects\dtl\dbs\enter_user2
Received on Fri Aug 25 2000 - 15:47:28 CDT