ACCEPT username CHAR PROMPT 'Enter the User Name >'
ACCEPT Default_Tablespace CHAR PROMPT 'Enter Default_Tablespace Name APPS_TS_TX_DATA , USERS >'
ACCEPT Temporary_Tablespace CHAR PROMPT 'Enter the TEMP Tablespace Name >'
spool /mnt/script/logs/create_user_`date`.log
create user &username identified by "Welcome123#"
default tablespace USERS
temporary tablespace TEMP1
profile NONADMIN
quota 5m on USERS;

ACCEPT role CHAR PROMPT 'Enter the Role : EBS_SUPER_USERS_RO , EBS_GENERIC_USERS_RO >'
grant create session, connect, &role to &username;

--ACCEPT DESCRIPTION CHAR PROMPT 'Enter Description for USER:'
--ACCEPT ITASK_NUMBER CHAR PROMPT 'Enter ITASK_NUMBER for USER:'

/*insert into xlcaudit.XX_USER_DESCRIPTION (USERNAME,DESCRIPTION,ITASK_NUMBER) VALUES ('&username','&DESCRIPTION','&ITASK_NUMBER'); */

commit;
spool off;