Assign access permissions for Oracle databases - 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.1 (2019)

The Reference Data installation delivers a set of script files. You must use these script files to create the necessary schemas, users, and roles that are used to run the software. The scripts must be run in the order listed.

Create Roles for Smart 3D users:

  • SP3DUser_ROLES.SQL

  • SP3DProjectAdministrator_ROLES.SQL

Create users for Smart 3D:

  • SP3DUser.SQL (for Oracle) or Linux_SP3DUser.SQL (for Linux)

Create Administrative users:

  • SP3DProjectAdministrator.SQL (for Oracle) or Linux_SP3DProjectAdministrator.SQL (for Linux)

Running these scripts is typically part of setting up the database server. See Initialize the Oracle Database in the Smart 3D Installation Help.