To create the account that will own the database objects you need to perform the following actions:
1. Download the script CREATE_USER.SQL and save it in your environment, for example in the folder C:\ORAFORMS_BOOK\SQL.
2. Obtain access to an Oracle Server instance with an account with schema creation privileges like SYSTEM.
3. Start SQL*Plus and connect to the Oracle Server instance.
4. At the SQL prompt type START <path>\CREATE_USER.SQL and press ENTER. Here, <path> is the location where you saved the file CREATE_USER.SQL. For example:
START
C:\ORAFORMS_BOOK\SQL\CREATE_USER.SQL
5. Provide the password for the account SYSTEM when prompted.
6. Provide the database name or connection string when prompted.
7. Provide the name of the new user when prompted.
8. Provide the password for the new user when prompted.
9. The script now lists all the tablespaces in the database and prompts you to enter the name of the default tablespace for the user. Enter the name of one of the listed tablespaces.
10. The script now prompts you to enter the name of the temporary tablespace for the user. Enter the name of one of the listed tablespaces.
11. Enter the disk quota to be observed by the new account.
12. Specify the tablespace on which the quota should apply. The tablespace name should be the same as the default tablespace.
At this point, the script creates the new account and grants it the necessary quota and privileges to create the database objects. The following listing is a sample log of the prompts, input and output you should expect when running the script.
SQL> start
d:\formsdisk\sql\create_user.sql
Please enter password for user SYSTEM :
*******
Enter database name or connection
string. Default is [LOCAL] : tstliv
Connected.
Enter new user name: oraforms
Enter password: ********
'Your database contains these tablespaces:
TABLESPACE_NAME
------------------------------
SYSTEM
RBS
TEMP
TOOLS
USERS
5 rows selected.
Enter default tablespace: users
Enter temporary tablespace: temp
Enter user quota (e.g. 100K, or 1M, or
UNLIMITED): unlimited
On tablespace: users
User created.
Grant succeeded.