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.
-
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.
-
Oracle database usernames are not allowed to contain spaces and the following characters: " . < , > ? \ / ' ; { } [ ] ~ ` ! % * ( ) & $ @ # - + ^ = |
-
Oracle database passwords are not allowed to contain spaces and the following characters: ' $ @ "
-
SQL Server database usernames cannot begin with a number, nor are they allowed to contain spaces and the following characters: " . < , > ? \ / ' ; { } [ ] ~ ` ! % * ( ) & $ @ #
-
SQL Server database passwords are not allowed to contain spaces and the following character: '
-
The software removes all spaces or special characters in a site name before using that name to create a default database user name.