Prepare Oracle

Before you can create multi-user workspaces where several users have access to the same data, first you need to prepare your common repository.

Prepare the database

Make sure the user who prepares the Oracle server for common repositories has the following access rights to all tables of the common repository: SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER.

To prepare your database, follow these steps:

  1. Create a database on the database server.

  2. To create the tables, adapt the Create Tables ORACLE.sql script to your requirements, and then run it.

    You can find the script in %COMMANDER_HOME%\SQL\Oracle.

What's next

Now that you have prepared the database, you can create your workspaces. For information on how to do so, see chapter "Create Oracle, MS SQL Server, or DB2 workspaces".