Understanding Default Database User Names - Intergraph Smart Engineering Manager - Installation & Upgrade - Intergraph

Intergraph SmartPlant Engineering Manager Installation and Upgrade

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
Smart Electrical Version
2015 R1 (7.1)
Smart Instrumentation Version
(none)
Smart P&ID Version
7.1 (2014 R1)
Smart Engineering Manager Version
7.2 (2014 R2)

Oracle and SQL Server databases require user names and passwords for each of the schemas and data dictionaries created by the New Site Server, New Plant Structure, Load Plant Structure, New Project, and Associate Applications wizards.

SmartPlant Engineering Manager uses the formulas in the following table to generate default values for these user names.

Schema Type

Database User Name

Example

Site Schema

Name of the site

Site1

Site Data Dictionary

Site Schema user name + 'd'

Site1d

Plant Schema

Name of the plant

Plant1

Plant Data Dictionary Schema

Name of the plant + 'd'

Plant1d

P&ID Schema

Plant schema user name + 'pid'

Plant1pid

P&ID Data Dictionary Schema

Plant schema user name + 'pidd'

Plant1pidd

Electrical Schema

Plant schema user name + 'el'

Plant1el

Electrical Data Dictionary Schema

Plant schema user name + 'eld'

Plant1eld

Electrical Reference Schema

Electrical schema user name + 'ref'

Plant1elref

Satellite Plant Schema

Plant schema user name + 'sat' + satellite count

Plant1sat1

Satellite P&ID Schema

Satellite plant schema user name + 'pid'

Plant1sat1pid

Satellite Replication Schema

Satellite plant schema user name + 'rep'

Plant1sat1rep

Project Schema

Plant schema user name + 'p' + project count

Plant1p1

Project P&ID Schema

P&ID schema user name + 'p' + project count

Plant1pidp1

Project Electrical Schema

Electrical schema user name + 'p' + project count

Plant1elp1

  • The software sets the related password defaults for the above user name automatically to <default user name> for Oracle and to <default user name> + '1' for SQL Server.  In the case of SQL Server 2014 running on Windows Server 2012, if you are using SQL Server authentication, you can specify that SQL Server is to use the password validation rules that are used by Windows Server 2012.

  • Database usernames cannot start with a numeric digit and cannot contain any of the following characters: ~ ` ! % ^ & * ( ) - + = { } [ ] \ / ; : ‘ " < > , . ? |

  • Oracle database user names are limited to 30 characters. Because site or plant names can be up to 64 characters long, the software truncates the characters to the maximum allowed by Oracle in creating the default database user names using the formulas above.

  • The software removes all spaces or special characters in a site name before using that name to create a default database user name.

  • Oracle database passwords cannot contain the characters: " ' @

  • SQL Server database passwords cannot contain the character: '

See Also

New Site Server Wizard
Load Plant Structure Wizard (see )
Associate Applications Wizard