Connecting to the Database - Intergraph Smart Instrumentation - Administration & Configuration

SmartPlant Instrumentation Configuration and Maintenance Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version
2016 SP1 (11.0.1)

The Internal Setup Utility allows you to connect to the Admin schema or Domain schema and then run various SQL commands to view or modify data in the tables.  On Oracle or SQL Server, if the Admin schema is not encrypted, any user can connect to the Admin schema, view user logon information, or update data in the Admin schema tables, or retrieve Domain schema logon information and then connect to the appropriate Domain schema.  If the System Administrator encrypted the Admin schema, you can connect to the Admin schema only if you know the Admin schema logon password.  For details about the Admin schema encryption, see Encrypt the Admin Schema Logon Password in the Administration help.

When you connect to the Admin schema, depending on whether the Admin schema password is encrypted or not, the software retrieves the Admin schema logon name and password in one of the following ways:

  • If the Admin schema is not encrypted, the software connects to the Admin schema using the Admin schema logon name and password from the Intools.ini file.  On an Oracle platform, the default logon name and password are IN_DBAMN.  On a SQL Server platform, the default logon name is SPI_DBAMN and the password is SPI_DBA.  It is possible to specify different settings during database setup.  In SQL Server, the name must be different from the password.

  • If the Admin schema is encrypted, the software connects to the INTOOLS_LOGIN schema and then retrieves the Admin schema logon name and password from the INTOOLS_LOGIN table.

When you connect to a Domain schema, the software performs the following actions:

  1. Connects to the Admin schema.

  2. After retrieving the Admin schema logon name and password, the software connects to the Domain schema and retrieves the Domain schema logon name and password from the PROJECT table of the Admin schema.

The following connection actions only apply when the domain type is Owner operator:

  • After connecting to the Domain schema, the software connects to a project schema (As-Built or project) and retrieves the logon name and password from the ENGINEERING_PROJECT table of the Domain schema.

  • When a user opens a project with As-Built items displayed, the software connects to the Combined Project schema and retrieves the logon name and password from the ENGINEERING_PROJECT table of the Domain schema.

See Also

Database Schemas
ODBC Profiles
Checking Database Version Compatibility