Bug 1078129

Summary:	On DB upgrade, readonly user and client custom users losses permissions to db views
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	rhev-integ
Component:	ovirt-engine-dwh	Assignee:	Eli Mesika <emesika>
Status:	CLOSED ERRATA	QA Contact:	Barak Dagan <bdagan>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	3.3.0	CC:	aberezin, acathrow, adahms, alonbl, bazulay, emesika, gklein, iheim, pstehlik, Rhev-m-bugs, sradco, yeylon, ylavi, yzaslavs, zdover
Target Milestone:	---	Keywords:	ZStream
Target Release:	3.3.3
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:	integration
Fixed In Version:	IS36 - rhevm-dwh-3.3.3-1.el6ev.noarch.rpm	Doc Type:	Bug Fix
Doc Text:	Previously, the read-only user and custom users for the data warehouse database would lose access to views in the database when the database was upgraded. This was caused by the views being regenerated when the database was upgraded and the permissions for those views not being applied to the newly generated views. Now, user permissions are retained when the database is upgraded.	Story Points:	---
Clone Of:	1073471	Environment:
Last Closed:	2014-05-27 16:20:51 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:	1073471
Bug Blocks:	1099132

Comment 1 Yaniv Lavi 2014-03-23 04:35:47 UTC

The patch for DWH is in. This should be in MODIFIED. The patch on engine 3.3 should be in a separate patch. Eli, please clone bug for engine 3.4 and 3.3.





Yaniv

Comment 4 Barak Dagan 2014-05-12 11:32:14 UTC

Verified on is36.1, 3.3.3:

rhevm-3.3.3-0.51.el6ev.noarch
rhevm-dwh-3.3.3-1.el6ev.noarch
rhevm-reports-3.3.3-1.el6ev.noarch


bash-4.1$ psql -h localhost -d ovirt_engine_history -U readonly -W
Password for user readonly:
psql (8.4.20)
Type "help" for help.

ovirt_engine_history=>

Comment 6 errata-xmlrpc 2014-05-27 16:20:51 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.

http://rhn.redhat.com/errata/RHSA-2014-0559.html