Re: insufficient privilege with pg_read_all_stats granted

2024-08-21 Thread Costa Alexoglou
> I think the problem is in the NOINHERIT attribute for the abcd role. Indeed that is the issue, thanks for helping find this out >

Re: insufficient privilege with pg_read_all_stats granted

2024-08-21 Thread Pavel Luzanov
On 21.08.2024 10:50, Pavel Luzanov wrote: But I don't understand why it worked in v14. Probablysomethinghas changed, butIcouldn't quicklyfindwhatexactly. Ifoundit. https://github.com/postgres/postgres/commit/6198420a -- Pavel Luzanov Postgres Professional:https://postgrespro.com

Re: insufficient privilege with pg_read_all_stats granted

2024-08-21 Thread Pavel Luzanov
On 20.08.2024 23:50, Costa Alexoglou wrote: I run PostgreSQL v15.8 (docker official image), and there is an issue when reading pg_stat_staments table with a result of query most of the times having `` value. I have created the user that I use to fetch the data with the following way: ``` CRE

insufficient privilege with pg_read_all_stats granted

2024-08-20 Thread Costa Alexoglou
Hey folks, I run PostgreSQL v15.8 (docker official image), and there is an issue when reading pg_stat_staments table with a result of query most of the times having `` value. I have created the user that I use to fetch the data with the following way: ``` CREATE USER abcd WITH NOSUPERUSER NOCREAT