Thread: pg_hba_file_rules permission issue
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/view-pg-hba-file-rules.html Description: Hi, 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 Thanks, Joby
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
Attachment
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