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.