Run Roles Scripts - Intergraph Smart 3D - Installation & Upgrade - Hexagon PPM

Intergraph Smart 3D Oracle Linux Installation and Configuration

Language
English (United States)
Product
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
13

At this point the Oracle instance should be up and running. Connect to the instance using SQLPlus (either from Linux itself or remotely from a Windows computer), and then execute the scripts to create the necessary roles for Smart 3D users.

  • Existing scripts delivered in the OracleScriptsToInitDB folder create SP3DUser\SP3DAdministrator user and roles with high level permissions on the Oracle server. However, if you want minimum mandatory privileges for these roles, then use the scripts delivered in the OracleScriptsToInitDB\MinimumAccessPrivileges folder instead.

  • Make a backup of the SP3DUser\SP3DAdministrator user and roles configuration if it already exists on the Oracle server.

  • The Molded Forms Copy by Family command should be run by a user with at least Project Administrator access on Oracle. This command will fail if you initialize the Oracle database with Minimum Access Privilege.

Create Roles with High Level Privileges

  1. Start SQLPlus and connect to the instance.

  2. Run the script:

    ..\Smart3D\ProjectMgmt\Tools\OracleScriptsToInitDB\SP3DUsers_Roles.SQL

  3. Run the script:

    ..\Smart3D\ProjectMgmt\Tools\OracleScriptsToInitDB\SP3DProjectAdministrator_Roles.SQL

Create Roles with Minimum Privileges

  1. Start SQLPlus and connect to the instance.

  2. Run the script:

    ..\Smart3D\ProjectMgmt\Tools\OracleScriptsToInitDB\MinimumAccessPrivileges\SP3DUsers_Roles_Def.SQL

  3. Run the script:

    ..\Smart3D\ProjectMgmt\Tools\OracleScriptsToInitDB\MinimumAccessPrivileges\SP3DProjectAdministrator_Roles.SQL