Oracle and SQL Server databases require user names and passwords for each of the schemas and data dictionaries created during the creation of a new site, plant, or project (using the New Site Server, New Plant Structure, Load Plant Structure, and New Project wizards), when associating an application, when restoring a backed-up site or plant, or when performing workshare activities.
If a general admin user does not have privileges for performing the above actions, the System Administrator can grant limited privileges to that user without compromising database security. For details, see the following topics in the Smart Engineering Manager Installation and Upgrade Help:
Smart 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 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 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 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.
-
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: '