Configuring your Database prior to Installation 16 • Create a new schema (refer topage 16) • Use an existing schema (refer topage 16). Creating a New Schema To create a new Oracle schema for use with Web TimeSheet: 1.    Install Oracle Client Tools (minimum version 10g release 2) on the web server where you will be installing Web TimeSheet. Restart the server after the installation. 2.    Sign into Oracle\OraHomexx\Application Development\SQL Plus using the default login (from the database you set up on your server): The SQL> prompt will be displayed. 3.    To create a new user, at the SQL> prompt enter: create user <user name> identified by <password>; 4.    To save the new user, select the Enter key on your keyboard. Oracle will notify you and return you to the SQL> prompt when the user is created. 5.    To provide the schema with connect and resource permissions, which are required to install the Or- acle version of Web TimeSheet, at the SQL> prompt enter: grant connect, resource to <user name>; 6.    Select the Enter key on your keyboard. Grant Succeeded will display. 7.    At the SQL> prompt, enter: grant query rewrite to <user name>; 8.    Select the Enter key on your keyboard. Grant Succeeded will display. Using an Existing Schema If you already have a schema set up for Web TimeSheet and want to use it again: 1.    Ensure Oracle Client Tools (minimum version 10g release 2) is installed on the web server where you will be installing Web TimeSheet. 2.    Sign into Oracle through SQL Plus. 3.    Delete all the tables, indexes, foreign keys, views, and sequences. Ensuring Oracle Data Provider Connectivity To prevent Oracle Data Provider (ODP) connection problems, all Oracle users using Windows must make a small alteration to their sqlnet.ora file. To do this: 1.    Open the sqlnet.ora file in a text editor. This file is located in your Oracle ...\network\admin folder (typically located in the Oracle folder, in your Oracle home folder). If you cannot find the file, create one as a text file saved at this location. Username: <System> Password: <Manager> Host String: <SID or Global database name>