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: '