Create Oracle Roles - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

Intergraph Smart 3D
Administration & Configuration
10.1 (2014 R1)

The Oracle Role Creation Utility is accessed from Start > All Programs > Intergraph Smart 3D > Database Tools. You should run this utility after creating a new Oracle model or after restoring an Oracle model.

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

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

  3. On the Oracle Role Creation Utility dialog box, 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 Oracle Role Creation Utility appends the permission to the existing role.

  6. Click Close when the process is complete.

See Also

Oracle Role Creation Utility Dialog Box