Re: pg_hba_file_rules permission issue - Mailing list pgsql-docs

From Joby John
Subject Re: pg_hba_file_rules permission issue
Date
Msg-id CAAHsARkE30XzX3rO1MsG4zxE_+sUJsVDzSA4koe4edw42R2=YQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_hba_file_rules permission issue  (Michael Paquier <michael@paquier.xyz>)
List pgsql-docs
Ok, thank you very much Michael

Joby

On 23 Feb 2018 2:09 pm, "Michael Paquier" <michael@paquier.xyz> wrote:
On Fri, Feb 23, 2018 at 09:41:27AM +0000, PG Doc comments form wrote:
> According to the documentation, I assume normal users will be able to view
> pg_hba_file_rules once they are granted select privileges. But for the
> privileged user it's giving following error while trying to view records:
>
> ERROR:  permission denied for function pg_hba_file_rules
> SQL state: 42501

I think that you need as well execution rights on pg_hba_file_rules() to
give access to it.
--
Michael

pgsql-docs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_hba_file_rules permission issue
Next
From: Daniel Westermann
Date:
Subject: Images in the official documentation