Bug 1023587

Summary: Additional Oracle Database Requirements when upgrading to Satellite 5.6
Product: Red Hat Satellite 5 Reporter: hmiles
Component: Docs Installation GuideAssignee: Dan Macpherson <dmacpher>
Status: CLOSED CURRENTRELEASE QA Contact: Dan Macpherson <dmacpher>
Severity: high Docs Contact:
Priority: medium    
Version: 560CC: mmello, pgervase, wburrows, xdmoon
Target Milestone: ---Keywords: Triaged
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-09-16 02:44:39 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1018166    

Description hmiles 2013-10-25 20:34:33 UTC 
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.
Comment 3 Dan Macpherson 2014-01-21 15:20:01 UTC 
This bug can be worked on early during the planning stages for Satellite 5.7.
Comment 6 Dan Macpherson 2015-09-16 02:44:39 UTC 
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.