Bug 1291271

Summary:	Deleting users who created activation keys deletes all associated keys
Product:	Red Hat Satellite	Reporter:	Craig Donnelly <cdonnell>
Component:	Content Management	Assignee:	Tom McKay <tomckay>
Status:	CLOSED ERRATA	QA Contact:	Brad Buckingham <bbuckingham>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	6.1.4	CC:	bbuckingham, sthirugn, stkachen, tomckay
Target Milestone:	Unspecified	Keywords:	Triaged
Target Release:	Unused
Hardware:	All
OS:	Linux
URL:	http://projects.theforeman.org/issues/12804
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-07-27 09:21:34 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 Craig Donnelly 2015-12-14 13:30:30 UTC

Description of problem:
If you delete any user who has previously created an activation key that still currently exists, the key(s) will be deleted as well.

Version-Release number of selected component (if applicable): 6.1.4

How reproducible: 100%


Steps to Reproduce:
1. Create a test user of any name (I set role as admin)
2. Login to this user and create an activation key.
3. Logout of the test user, back in as another admin, and delete the user.
4. Check the activation key list.

Actual results:
Newly created activation key will now be gone.

Expected results:
Activation key should still exist.

Additional info:
This association appears to be inside of the foreman database, inside the katello_activation_key table. The 'user_id' column has the number of the user who created the activation key. If you set this id to any other user prior to deleting the one who currently owns the key, the key will continue to exist after user deletion.

Comment 1 Tom McKay 2015-12-14 13:39:46 UTC

Created redmine issue http://projects.theforeman.org/issues/12804 from this bug

Comment 3 Bryan Kearney 2015-12-14 15:01:11 UTC

Upstream bug component is Content Management

Comment 4 Bryan Kearney 2015-12-21 23:01:18 UTC

Moving to POST since upstream bug http://projects.theforeman.org/issues/12804 has been closed
-------------
Thomas McKay
Applied in changeset commit:katello|01e8b42104c8a5ff532273c52730b680fa34a4a6.

Comment 6 Brad Buckingham 2016-03-24 19:28:02 UTC

Executed the scenario as described in the initial description.  After deleting the user, observed that the activation key continues to exist as desired.

Comment 9 errata-xmlrpc 2016-07-27 09:21:34 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2016:1501