Oracle Database Authentication - Intergraph Smart 3D - Installation

Intergraph Smart 3D Oracle Linux Installation and Configuration

Language
English
Product
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
11 (2016)

Smart 3D needs a database user to connect to an Oracle Linux server. We recommend that you create two database users: one user for administrative access and one user for general users.

You must also create database login .ini files. The .ini files contain the database server name, user name, and password Smart 3D is to use to connect to the databases. For more information, see Create Database Login ini File.

Oracle User for Administrators

  1. Open ..\Smart3D\ProjectMgmt\Tools\OracleScriptsToInitDB\Linux_SP3DProjectAdministrator.SQL in an editor.

    If you create the SP3DAdministrator roles with minimum privileges, then use the ..\Smart3D\ProjectMgmt\Tools\OracleScriptsToInitDB\MinimumAccessPrivileges\ Linux_SP3DProjectAdministrator.SQL. to create the SP3D Administrator user.

  2. Change nativeadmin to the user name that you want to use as an administrator.

  3. Change manager on line 8 to the user name password for the administrator.

  4. Connect to the Oracle instance as the sys account and run the script.

  5. Run a SQLPlus connectivity test to verify that the new Oracle login can connect successfully.

Oracle Users for Non-Administrator Users

  1. Open ..\Smart3D\ProjectMgmt\Tools\OracleScriptsToInitDB\Linux_SP3DUser.SQL in an editor. If you created the SP3DUser role with minimum privileges, then use the ..\Smart3D\ProjectMgmt\Tools\OracleScriptsToInitDB\MinimumAccessPrivileges\Linux_SP3DUser.SQL to create the SP3D non- administrator user.

  2. Change nativeuser to the user name that you want to use for the user.

  3. Change manager on line 7 to the user name password.

  4. Connect to the Oracle instance as the sys account and run the script.

  5. Run a SQLPlus connectivity test to verify that the new Oracle login can connect successfully.

Grant Privileges to SP3D User Role

You should execute this process only if you have created the Smart 3D roles with minimum mandatory privileges using the scripts delivered in the OracleScriptsToInitDB\MinimumAccessPrivileges folder. The SP3DAdministrator should create all seven Smart 3D databases (Site, Site Schema, Catalog, Catalog Schema, Model, Report, and Report Schema) using the Smart 3D utilities.

  1. Connect to the Oracle instance as the sys account and run the script:

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

  2. At the Enter value for database name: prompt from SQL, type the Site database name.

  3. Rerun the SP3DUser_ROLES_Access.SQL script six more times, providing the Site Schema, Catalog, Catalog Schema, Model, Report, and Report Schema database names as you did for the Site database in step 2.

  • Any typed alpha character must be capitalized.

  • In the future, the Oracle administrator must run SP3DUser_ROLES_Access.SQL on all seven Smart 3D databases when there are any schema enhancements in databases. For example, whenever a view, procedure, new table, or any new object is added to the database, the Oracle administrator must grant permissions on each new object by running this script.

  • If you use minimum access privileges, there is an additional administrative burden on the Oracle database administrator to add permission on newly created database objects to the SP3D User role.