The set of database privileges needed for the Update Manager installation and upgrade differs from the set of privileges needed for the Update Manager administration.

Before installing or upgrading Update Manager, you must grant adequate privileges to the database user.

Table 1. Database Privileges Needed for Installation or Upgrade of Update Manager
Database Privileges
Oracle Either assign the DBA role, or grant the following set of privileges to the Update Manager Oracle 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
Microsoft SQL Server Make sure that the database user has either a sysadmin server role or the db_owner fixed database role on the Update Manager database and the MSDB database. Although the db_owner role is required for the upgrade, SQL jobs are not created as part of the Update Manager installation or upgrade.

To run Update Manager, you must grant a set of minimum privileges to the database user.

Table 2. Database Privileges Needed for Using Update Manager
Database Privileges
Oracle The minimum required privileges of the Oracle database user are the following:
  • create session
  • create any table
  • drop any table
Microsoft SQL Server The database user must have either a sysadmin server role or the db_owner fixed database role on the Update Manager database and the MSDB database.