Running the Initialize Database Script as the DBA or System User

This script creates the TIBCO BusinessEvents user and initializes the database.

The tutorial uses the default username (BE_USER) and password (BE_USER). You can change the username by editing the BE_HOME/bin/ initialize_database YourDBMS.sql script.

Warning: Running the initialize_database YourDBMS.sql script deletes the user before creating it again. Running the create_tables_YourDBMS.sql drops all database tables before creating them again. This means you can run these scripts again during test phases of your project development, without having to take extra cleanup steps.

Procedure

Ensure your DBMS is running. Open a command window in BE_HOME/bin (default location of the scripts) and type the following command for Oracle (if you use the default SID you can omit @SID):
```
sqlplus sys_user/sys_user_password@SID/@initialize_database_oracle.sql
```
Type exit to exit and commit.

If you are using SQL Server, use this instead:
```
osql -S Your-Server -U sys_user -P sys_user_password -n -i initialize_database_sqlserver.sql
```
This script creates the TIBCO BusinessEvents database user. This user must be used to run the other scripts. You see messages like the following:
```
   User dropped.
   User created.
   Grant succeeded.
```
Tip: Using your database product, you can configure additional users to access the database, in addition to this user.