Re: privileges oddity - Mailing list pgsql-general

From Tom Lane
Subject Re: privileges oddity
Date
Msg-id 2637375.1596739138@sss.pgh.pa.us
Whole thread Raw
In response to Re: privileges oddity  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: privileges oddity  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-general
Scott Ribe <scott_ribe@elevated-dev.com> writes:
> On Aug 6, 2020, at 12:22 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Gonna need more context.  The session-level user seems to have the
>> right privileges, but maybe something is happening inside a
>> security-definer function that doesn't have privileges?

> The only security definer function in the db is a simple pg_shadow lookup used by pgbouncer.

Hmph.  Any chance of getting a stack trace from the point of the error?
Also, which PG version is this?

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: privileges oddity
Next
From: Scott Ribe
Date:
Subject: Re: privileges oddity