Created On:  30 November 2010
Modified On:  6 May 2013

Problem:

This Oracle database error was generated when upgrading from StarTeam 2008 to 2009:

Resolution:

This is because some of the required user privileges or roles are missing.

The StarTeam Oracle schema user must have these privileges granted:
  • Create Any Procedure
  • Create Any Sequence
  • Create Procedure
  • Create Sequence
  • Create Session
  • Create Table
  • Create Trigger
  • Create Type
  • Create View
  • Unlimited Tablespace
  • Create Any context
  • Drop Any context

The StarTeam Oracle schema user must have these additaional roles granted

  • CONNECT
  • DBA (default role)
  • RESOURCE

You will need to login as system user to grant these roles and privileges by running command:

grant <roles or privilege> to <username>

You may choose to revoke the DBA role upon successful upgrade.

Incident #2488907