Re: Access issue for system queries

2024-03-29 Thread arun chirappurath
Ok, I'll check it out. Thank you. On Sat, 30 Mar, 2024, 10:36 Julien Rouhaud, wrote: > On Sat, Mar 30, 2024 at 12:47 PM arun chirappurath > wrote: > > > > I have granted access to pg_read_all_stats and pg_read_allsettings to > user..still they are not able to receive results from this query

Re: Access issue for system queries

2024-03-29 Thread Julien Rouhaud
On Sat, Mar 30, 2024 at 12:47 PM arun chirappurath wrote: > > I have granted access to pg_read_all_stats and pg_read_allsettings to > user..still they are not able to receive results from this query.its > empty..we can run SELECT * FROM pg_stat_statements alone..but not below > statement..what

Access issue for system queries

2024-03-29 Thread arun chirappurath
Dear all, I have granted access to pg_read_all_stats and pg_read_allsettings to user..still they are not able to receive results from this query.its empty..we can run SELECT * FROM pg_stat_statements alone..but not below statement..what could be the reason? WITH statements AS ( SELECT * F