Standard Oracle System Users

Create Database users

The OSM database is accessed by a set of standard Oracle system accounts.

During the Create New OSM Database process, the following users will be created:

• cow_owner

• cow_read

• cow_user

In the default instance, the password for the users will be equal to user name.

cow_owner

The cow_owner account is the database user that owns every table and can do everything on the whole OSM database.

• The cow_owner user can delete tables and database objects.

• When upgrading, you will need to use cow_owner account in order to change the structure of the database.

• Password should be changed from default and strictly controlled to only a few people.

cow_read

The cow_read account owns the standard views that are used by other users to view data.

• The cow_read user can only read OSM data. It has no write permissions to OSM database, but can add, change, drop standard views.

• Standard views are read-only to other employees, such as data analysts or administrators.

• Password should be changed from default and given only to employees who need to analyze data.

cow_user

The cow_user account is used by the OSM applications (both Web app and Admin) to logon to select, update, delete, insert data into OSM database.

• It cannot delete or change tables or any database objects owned by cow_owner.

• The OSM installer program will ask for this password to connect to the OSM database.

• Password should be changed from default one time and given only system administrators.

  Important The cow_user password should be changed from default only one time. Once changed it should NOT be changed again. Changing the password for Oracle system account cow_user after installing OSM Web application and/or OSM Administration application will cause you to need to reinstall OSM Administration, Web Application, and Mobile applications with the new cow_user password.

Valid passwords

These are guidelines for valid passwords for OSM Database accounts:

• Password must be at least 4 characters and cannot exceed 32 characters.

• Characters must have ascii values from 33 to 126.

Valid password characters

These are the valid characters for passwords for OSM Database accounts:

• a to z

• A to Z

• 0 (zero) to 9

• ! # % ( ) = ? $ { } [ ] + - \ * : , . < > _

Other characters are not valid.

• Examples of characters that are not valid: " (double quote), ' (single quote), " " (space) | (pipe) @ / &