Bug 476573

Summary:	multi-org, shared channels is not allowing users to view details, ISE
Product:	[Community] Spacewalk	Reporter:	Shannon Hughes <shughes>
Component:	WebUI	Assignee:	Jeff Ortel <jortel>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	medium	Docs Contact:
Priority:	low
Version:	0.4	CC:	jesusr, jortel, whayutin
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
URL:	rhn/software/packages/Details.do?pid=7581
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2009-01-22 16:38:09 UTC	Type:	---
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:	475365
Bug Blocks:	456552, 476893

Description Shannon Hughes 2008-12-15 19:47:46 UTC

+++ This bug was initially created as a clone of Bug #475365 +++

Description of problem:

we need to modify the verification for a user access to package details. looks like we are joining against rhnAvailableChannels which does not query the trusted orgs to allow access to users of trusted organizations that own the package. 

UserManager class [verify package access] -> query for rhnavailablechannels and rhnchannelpackage

Expected results: 

users of trusted orgs viewing shared channels should have access to the package details.

Comment 1 Jeff Ortel 2008-12-17 16:10:26 UTC

After looking at this, it seemed to make sense to update the rhnAvailableChannels view to included shared channels.  Making this change fixes this issue and doesn't appear to have any negative side affects on other pages/functionallity.  

Since this is a schema change, the following schema upgrade scripts need to be run before testing (or reload the schema):

/schema/spacewalk/upgrade/spacewalk-0.3-spacewalk-0.4

122-rhn_channel.pkb
144-rhnSharedChannelTreeView.sql
145-rhnAvailableChannels.sql