This procedure allows you to encrypt the logon password of the Smart Instrumentation database schema that stores the encrypted Admin schema password. It is impossible to revert to non-encrypted method of password storage. Depending on the database platform, the security schemas are as follows:
-
INTOOLS_LOGIN is a Smart Instrumentation database schema created only in Oracle during the database setup. This schema stores the encrypted Admin schema password in the database. The schema logon name and password are both intools_login. The logon name is set permanently in the software. The System Administrator can change and encrypt the intools_login password if needed.
-
SPI_login is a Smart Instrumentation database schema (database user) created only in SQL Server during the database setup. Each SPI_login schema stores the encrypted Admin schema password in the database. This schema login is shared for all databases you create in a SQL Server instance. For example, if you create SPI1 and SPI2 databases in the same instance, each database contains the SPI_login schema but, at the instance level, both schemas share the same login, whose name is SPI_login and password is spi_login_pwd (lower case). The login name is set permanently in the software. The System Administrator can change and encrypt the spi_login_pwd password if needed.
-
With the System Administration window open, click DBA > Security Options > Encrypt Security Schema Password.
The password characters appear masked.
-
Click OK to encrypt the password in the intools.ini file.
The encryption process is irreversible.
For more information, see Working with the Command Line Interface (Silent Mode) in the Administration Module.