Red Hat Bugzilla – Bug 1023587
Additional Oracle Database Requirements when upgrading to Satellite 5.6
Last modified: 2015-10-05 22:33:16 EDT
Description of problem:
We should add to this section :
22.214.171.124. Oracle Database Requirements
In addition to this statement :
The precise access levels required by the Oracle user are as follows:
We should add the following :
note: the database user has to have privileges above granted directly (not via role)
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:
Closing this bug.