Oracle and SQL Server databases require user names and passwords for each of the schemas and data dictionaries created by the Create site, Create plant, Load plant, and Associate application requests.
It is recommended that you use the formulas in the following table when assigning 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 |
-
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 running on Windows Server, 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.
-
Database user names are limited to 30 characters. Because these are derived from site or plant names that can be up to 64 characters long, the software truncates any excess characters to the maximum allowed in creating the default database user names using the formulas above.
-
Database usernames are not allowed to contain spaces and the following characters: . < , > ? \ / ' ; { } [ ] ~ ` ! % * ( ) & $ @ # " - + ^ = | In addition, SQL Server database usernames are not allowed to begin with a number.
-
Oracle database passwords are not allowed to contain spaces or the following characters: ' $ @ "
-
SQL Server database passwords are not allowed to contain spaces or the character: '
-
The software removes all spaces or special characters in a site name before using that name to create a default database user name.