Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1epF4A-0007ym-5B for pgsql-docs@arkaria.postgresql.org; Fri, 23 Feb 2018 15:15:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1epF49-0007cN-AP for pgsql-docs@arkaria.postgresql.org; Fri, 23 Feb 2018 15:15:17 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1epF49-0007bw-1e for pgsql-docs@lists.postgresql.org; Fri, 23 Feb 2018 15:15:17 +0000 Received: from mail-ua0-x234.google.com ([2607:f8b0:400c:c08::234]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1epF46-00034X-JJ for pgsql-docs@lists.postgresql.org; Fri, 23 Feb 2018 15:15:15 +0000 Received: by mail-ua0-x234.google.com with SMTP id b23so3482183uak.9 for ; Fri, 23 Feb 2018 07:15:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=ANMBPO721B8mAOhfPYaoLC9owikC07ZC0SZfHECUvsc=; b=bB8mEmJK/y8OqU1O6wsjBfkQN4UyhAsbdOOtI7t+NaU2On3Pkf/BfsWRTjh6DvCYoY 4s8IMZGo9tPt0AFztTkyAr1Am4dIEYHWJqD8xnNAmanyzRnzrPAPsXUhry8ZrsqkQ0yu tMSzgUHrgImJ2pMQHZBBmXAargzDD/5ccPQw5XLtFyCMCgg1rb4vOiCs85drH4bbZ5qR RqQGlsxHNrWZ0d2qmv2fMDZ3BmEud8OsC6j4+qZXqY2lKLmx0CMc3x3YwyJtrAs5KBbT YQ46LOurXi86AJNscPtA3wDP0Mu21POO85wc0/4zKArKTUjWv48tGvqq0LGTzRoinmkq VYwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=ANMBPO721B8mAOhfPYaoLC9owikC07ZC0SZfHECUvsc=; b=s7z1OaqlAPEFn/oItBJcJ8j0urENGbHLeJmnggLn+nunX2N83XKt0muU/Ym8nZpCkw 58vgTh7ofeyY28XHWJUb6basNGnbwWjsohvb8r0Nlt4Nc1RGGEslLSAab+/9U478upYs GQY++j0m9UcPFfch5P3CVbSmo0N9fKTm062iXktnXa9y11xLqWVdov1h+nDSK/QDcxUb lGJdLJMYrRXHmEo16qO3/XztHyZMJdiX1QaZkAOI1cra46xuaMZk574UQzbrEgm69Lai bDC+VrnW6VV7TQxqvV6W6UKFEVdEnaJB3Ir+82xqOmkPq1IH0nMCfu3I4tsZp3RzR3hO LBBg== X-Gm-Message-State: APf1xPCD/2+EHxfd9Qx1oblANvUG0qisz5U4sA1ATeGb0xS0L5zmV3pc 8O6uQV5HT7TAPlKFRyW5yH2c+TND/XgyZxkzXTk= X-Google-Smtp-Source: AG47ELtL34YrF991lhol/lmqFH1MzLvMi7CEoKOH3gIaz8ZD/IOR7sElhyCx7sjGLYcY/GE/W6G94XX1hQcbo00sEag= X-Received: by 10.176.68.35 with SMTP id m32mr1501241uam.5.1519398913477; Fri, 23 Feb 2018 07:15:13 -0800 (PST) MIME-Version: 1.0 Received: by 10.176.28.13 with HTTP; Fri, 23 Feb 2018 07:15:13 -0800 (PST) Received: by 10.176.28.13 with HTTP; Fri, 23 Feb 2018 07:15:13 -0800 (PST) In-Reply-To: <20180223140926.GC9580@paquier.xyz> References: <151937888789.1456.18376747263583744706@wrigleys.postgresql.org> <20180223140926.GC9580@paquier.xyz> From: Joby John Date: Fri, 23 Feb 2018 15:15:13 +0000 Message-ID: Subject: Re: pg_hba_file_rules permission issue To: Michael Paquier Cc: pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="94eb2c06a2c082922f0565e2a0aa" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --94eb2c06a2c082922f0565e2a0aa Content-Type: text/plain; charset="UTF-8" Ok, thank you very much Michael Joby On 23 Feb 2018 2:09 pm, "Michael Paquier" 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 > --94eb2c06a2c082922f0565e2a0aa Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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 r= ecords:
>
> ERROR:=C2=A0 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
--94eb2c06a2c082922f0565e2a0aa--