Bug 819669

Summary: Listing systems with all environment read_systems permission lists no systems
Product: Red Hat Satellite Reporter: Justin Sherrill <jsherril>
Component: HammerAssignee: Justin Sherrill <jsherril>
Status: CLOSED UPSTREAM QA Contact: Katello QA List <katello-qa-list>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.0.1CC: mmccune
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-09-19 18:11:00 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:

Description Justin Sherrill 2012-05-07 22:41:09 UTC
Description of problem:


Steps to Reproduce:
1. Create a new user with no permissions
2. Create a new role with 1 permission for a single org:  "Read Systems in environment"  and select "+ALL" instead of selecting individual environments
3.  assign the role to the newly created user
4. Register one or more systems to an environment in that org
5. list systems from the cli
  
Actual results:
No systems found

Expected results:
All registered systems found


Additional info:

In Systems.rb  we need to change a few lines of code from:

#{User.allowed_tags_sql(KTEnvironment::SYSTEMS_READABLE, :environments, org)})

To #{KTEnvironment.systems_readable(org).select(:id).to_sql}

Within the System.readable  function.

Comment 1 Justin Sherrill 2013-01-22 16:09:33 UTC
was fixed in  e8bfbcdba4800efa6f542f0bd41243feeb047bac

Comment 2 Mike McCune 2013-08-16 17:57:07 UTC
getting rid of 6.0.0 version since that doesn't exist

Comment 3 Mike McCune 2013-09-19 18:11:00 UTC
These bugs have been resolved in upstream projects for a period of months so I'm mass-closing them as CLOSED:UPSTREAM.  If this is a mistake feel free to re-open.