Created On:  06 December 2011

Problem:

During a DataMart extraction the following error occurs in the log file:

Cannot find the object "ST_VIEWMEMBER" because it does not exist or you do not have permissions

Resolution:

This error occurs because DataMart does not have DBO permissions on the database. Both the StarTeam source database and the DataMart destination database require DBO rights to be granted.

The database user needs permissions to Update, Insert and Delete from the DataMart tables. DBO rights are also needed for extractions when custom fields have been added to the StarTeam source database. 

In the context of security, DBO means that the user is the owner for only one database. This user will not have any rights on any other database other than the DataMart database.
Incident #2543491