Assigning Database User Names - Intergraph Smart Engineering Manager - Help - Intergraph

Intergraph Smart Engineering Manager Smart API Help (2.0)

PPMProductFamily
Engineering and Schematics
PPMProduct
Intergraph Smart Engineering Manager
PPMCategory
Help
Version_WebSEM
2.0

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.