Granting Oracle Privileges

If your StarTeam Server configuration uses an Oracle schema user that was not created automatically by StarTeam Server, you should check it for all the privileges listed below. These privileges ensure that StarTeam Server can create labels and perform other operations successfully and should be explicitly defined rather than relegated to a role.

  • Create procedure
  • Create sequence
  • Create session
  • Create table
  • Create trigger
  • Create type
  • Create view
  • Unlimited tablespace
  • Create any context
  • Drop any context

The following procedure explains how to explicitly define Oracle privileges, using the Create type privilege as an example.

To explicitly define the Create type privilege:

  1. Log on to the database as system user.
  2. Execute the following SQL statement: grant create type to schema_user, where schema_user is the name of the Oracle schema user.