Bug 990095
| Summary: | [rhevm-dwh_33] - database - postgresql query doesn't work with read-only user | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | David Botzer <dbotzer> | ||||
| Component: | ovirt-engine-dwh | Assignee: | Sandro Bonazzola <sbonazzo> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Barak Dagan <bdagan> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 3.3.0 | CC: | acathrow, iheim, oschreib, pstehlik, Rhev-m-bugs, sbonazzo, yeylon, ylavi | ||||
| Target Milestone: | --- | Keywords: | Triaged | ||||
| Target Release: | 3.3.0 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | integration | ||||||
| Fixed In Version: | rhevm-dwh-3.3.0-7.el6ev.noarch.rpm | Doc Type: | Bug Fix | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 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: | |||||||
| Attachments: |
|
||||||
Please give this bug devel_ack, if it is fixed Verified on IS21:
rhevm-reports-3.3.0-19.el6ev.noarch
jasperreports-server-pro-5.5.0-4.el6ev.noarch
rhevm-dwh-3.3.0-19.el6ev.noarch
#psql -U readonly -h my.rhevm.com ovirt_engine_history
ovirt_engine_history=> select distinct vm_pool_id, vm_pool_name from vm_configuration where vm_pool_id is not null;
vm_pool_id | vm_pool_name
--------------------------------------+--------------
9d95b43d-fbea-42f7-88ca-c708d0eac3fb | pool1
77f17c61-56c8-4985-b7f4-1cda87f22b1d | pool2
Closing - RHEV 3.3 Released Closing - RHEV 3.3 Released Closing - RHEV 3.3 Released |
Created attachment 780569 [details] readonly user Description of problem: query works with engine_history user (who is the db owner) and postgres, But doesn't work with read-only user Version-Release number of selected component (if applicable): 3.3/is7 How reproducible: always Steps to Reproduce: 1.I ran dwh-setup on is7, and during which I have created the readonly user 2.This user can connect to DB remotly, but doesnt have permissions to display any table/view psql -U dave -h 10.x.x.x ovirt_engine_history 3. Actual results: select * from v3_3_configuration_history_vms; ERROR: permission denied for relation v3_3_configuration_history_vms Expected results: should show tables as for other users Additional info: other user is working - engine_history and postgres (postgres works localy) psql -U engine_history -h 10.x.x.x ovirt_engine_history