Upgrade vc from 4.0 to 4.01 issue #1

Upgrade update manager gives error "no correct privileages"

When you upgrade Update Manager an error message during the database upgrade might appear
When you upgrade Update Manager, you have to upgrade the database. If you use an Oracle database and grant the user only the connect privilege, an error message for insufficient privileges is displayed. Even if you provide the user the execute on dbms_lock, create procedure, create sequence, create table, create any sequence, and the create any table privileges, the database upgrade fails.

Workaround: Grant the following set of privileges to the Update Manager database user:
connect
execute on dbms_lock
create view
create procedure
create table
create sequence
create any sequence
create any table
create type
unlimited tablespace

e.g.

grant create all table to vpxadmin;