Oracle Role Creation Utility - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
12 (2018)

Enables you to define more conservative roles based on object privileges in the Oracle database. You can define specific user roles for each schema or collection of schemas if necessary. For example, Server 1 is the site and model schemas and Server 2 is the catalog and reports schemas. You can have different roles defined for each Oracle schema and your users will need permission to use each role. This is acceptable even if the roles have exactly the same names.

To access the utility, click Start > All Programs > Intergraph Smart 3D > Oracle Role Creation Utility. You should run this utility after creating a new Oracle model or after restoring a Oracle model.

If you start working with the SP3DUSER global role but decide to change to more conservative Oracle roles, you can revoke the existing SP3DUSER role, then add the new roles.

Oracle service

Shows the name of the Oracle net service for the database connection.

Role name

Identifies a user-defined string for the new role. 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.

Add permissions to role on selected schemas

Lists the names of the possible databases where you can create the role. The list is filtered based on the selected Oracle service. You can select one or more databases.

Create

Adds the new Oracle role to the selected schemas. 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 for use.

If the new role already exists in the Oracle database, the Oracle Role Creation Utility appends the permission to the existing role.

Close

Closes the utility.

What do you want to do?