Admin Schema - 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 Admin schema holds administration data managed by the System Administrator. The logo name and password of the Admin schema depend on your database platform.

Admin Schema in a SQL Server Database

The software creates the Admin schema in your SQL Server instance on the database server when you run the DB Setup Utility. The default Admin schema logon name is SPI_DBAMN. The default Admin schema logon password is SPI_DBA. System Administrator can redefine the default name and password when running the DB Setup Utility, provided that the schema password is different from the schema name.

Admin Schema in an Oracle Database

The software creates the Admin schema in your Oracle instance on the database server when you run the DB Setup Utility. The default Admin schema logon name and password is IN_DBAMN.  System Administrator can redefine the default name and password when running the DB Setup Utility.

The software adds the Oracle role DBA with maximum privileges to the Admin schema. The software uses the DBA role when running the DB Setup Utility, initializing a new domain, or upgrading the software.  Furthermore, the following Administration module activities cannot be performed without the DBA role:

  • Assigning Administrator rights

  • Deleting a domain

  • Deleting an invalid domain

  • Accessing the database

  • Encrypting passwords of users

  • Managing security

  • Resizing tablespaces

  • Working with the tablespace list

  • Rebuilding catalog tables

  • Rebuilding stored procedures and triggers

  • Rebuilding domain views

  • Clearing locking

By default, regardless of the database platform, the Admin schema logon password is not encrypted. On Oracle or SQL Server, if needed, the System Administrator can encrypt the Admin schema logon password. See Encrypt the Admin Schema Logon Password in the Administration help. When encrypting the password, the software removes the Admin schema logon name and password from the Intools.ini file and stores this data in the INTOOLS_LOGIN table of the INTOOLS_LOGIN schema.

See Also

Connecting to the Database