Description of problem: We should add to this section : 2.3.3.2. Oracle Database Requirements https://access.redhat.com/site/documentation/en-US/Red_Hat_Satellite/5.6/html-single/Installation_Guide/index.html#sect-Installation_Guide-External_Database_Requirements In addition to this statement : ================= The precise access levels required by the Oracle user are as follows: ALTER SESSION CREATE SEQUENCE CREATE SYNONYM CREATE TABLE CREATE VIEW CREATE PROCEDURE CREATE TRIGGER CREATE TYPE CREATE SESSION ================= We should add the following : ================= note: the database user has to have privileges above granted directly (not via role) Example : SQL> grant CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, CREATE PROCEDURE,CREATE TRIGGER, CREATE TYPE, CREATE SESSION, ALTER SESSION to rhnsat; ================= There have been 2 support cases so far where customer's using external db's did not have this set and they were unable to upgrade.
This bug can be worked on early during the planning stages for Satellite 5.7.
This note has been live since the 5.7 release: https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html/Installation_Guide/sect-Scenario_3_Installing_Satellite_with_External_Database.html#sect-External_Database_Requirements Closing this bug.