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
Ok, thank you very much Michael
Joby
On 23 Feb 2018 2:09 pm, "Michael Paquier" <michael@paquier.xyz> wrote:
Show quoted text
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: 42501I think that you need as well execution rights on pg_hba_file_rules() to
give access to it.
--
Michael