Create Oracle roles - Intergraph Smart 3D - Administration & Configuration

You run this utility after creating a new Oracle model or after restoring an Oracle model.

1. After you create the Oracle site and catalog databases using standard procedures, create a new model in Project Management.

2. After you create the new model, click Start > All Programs > Intergraph Smart 3D > Oracle Role Creation Utility.

3. Specify an Oracle service and a new role name. For the role name, you can type the name of an existing Oracle role that is being used for other models at this site or use a different role for each model.

4. Select the appropriate databases from the list.

5. Click Create. A status bar shows processing information while the Oracle tables update. It is estimated that it will take 3-4 minutes per schema, or approximately 20 minutes per model configuration (7 schemas), to create a new role, and creating all of the Oracle roles is required before the model is available.

   If the new role already exists in the Oracle database, the utility appends the permission to the existing role.

6. Click Close when the process is complete.