From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | jobyjc(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15081: pg_hba_file_rules permission issue |
Date: | 2018-02-23 15:13:06 |
Message-ID: | CAKFQuwYLh7TgOGAhjdwHLANB-W7dpvtpUuUxmr9hqpyD3ZT7uQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Fri, Feb 23, 2018 at 8:06 AM, PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 15081
> Logged by: Joby John
> Email address: jobyjc(at)gmail(dot)com
> PostgreSQL version: 10.2
> Operating system: Windows 10
> Description:
>
> Hi,
> To get access to pg_hba_file_rules view, user needs execute privilege on
> pg_hba_file_rules() function too.
>
> But I think this is not the normal behaviour as I can give access to
> pg_shadow view without granting access to pg_authid table even though
> pg_authid is used inside pg_shadow.
>
pg_authid is a table/view while pg_hba_file_rules() is a function. For
better and worse functions always execute as the user running the query
while access to tables and views is done as the owner of the view. being
accessed.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Joby John | 2018-02-23 15:14:30 | Re: BUG #15081: pg_hba_file_rules permission issue |
Previous Message | PG Bug reporting form | 2018-02-23 15:06:03 | BUG #15081: pg_hba_file_rules permission issue |