Admin Schema - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Internal Setup

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
2018 (12.0)

The Admin schema holds Smart Instrumentation 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. Smart Instrumentation 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. Smart Instrumentation 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 Smart Instrumentation 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. For more information, see Encrypt the Admin Schema Logon Password in the Administration Module 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 Smart Instrumentation Database