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.
Database | Privileges |
---|---|
Oracle | Either assign the DBA role, or grant the following set of privileges to the Update Manager Oracle database user.
|
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.
Database | Privileges |
---|---|
Oracle | The minimum required privileges of the Oracle database user are the following:
|
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. |