Open gowtham500 opened 3 years ago
Hello,
I was able to resolve this issue as the user used by the collector - powa_user (in my case) didnt have access to pg_statistic.
Hello @gowtham500
I reopened this issue to see if I can improve the UI by adding a better error message in that case. Ideally hinting for granting adequate privileges on pg_statistics, but if that's not easily doable at least showing the error message so it's easier to track down the root issue.
Thanks for adding this as part of enhancement.
I also noticed that the user used by the collector - ex: powa_user requires SELECT permission on the target table for it to run EXPLAIN - so that we get output from predicates section up above and also to get output from "OPTIMIZE DATABASE". Is this understanding correct ?
If so, is there any alternative to run give permission to run EXPLAIN without granting access to read the table?
I don't think it's possible to get EXPLAIN without access to the table.. I understand your security concern ... Also in the same boat cannot implement it in PRD environment
пт, 12 лют. 2021 о 21:03 Gowtham Raj Elangovan notifications@github.com пише:
Thanks for adding this as part of enhancement.
I also noticed that the user used by the collector - ex: powa_user requires SELECT permission on the target table for it to run EXPLAIN - so that we get output from predicates section up above and also to get output from "OPTIMIZE DATABASE". Is this understanding correct ?
If so, is there any alternative to run give permission to run EXPLAIN without granting access to read the table?
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/powa-team/powa-web/issues/128#issuecomment-778564351, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIHWEYEAZGVPC4YV7JH3RMDS6YBZLANCNFSM4XMX2BRA .
Hello team,
Versions - Remote server
powa-4.1.2 PostgreSQL 12
Versions - Central Repository
powa-4.1.2 powa-collector powa-collector.py version 1.1.1 PostgreSQL 13
Version powa-web
powa-web-4.1.0
Error
Observation
I just checked that backend query for this operation by enabling - log_min_duration_statement:0 and it executes below query for the that particular query id. I tried it on the DB with the same UI user, and I got output back. But in web I see above error. Can you please advise.
Output of above query when executed as the same web ui user.