Re: privileges oddity - Mailing list pgsql-general

From Scott Ribe
Subject Re: privileges oddity
Date
Msg-id 3BB973D9-71E3-445C-ABD3-24C0FF32B6E4@elevated-dev.com
Whole thread Raw
In response to Re: privileges oddity  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> On Aug 6, 2020, at 12:38 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Hmph.  Any chance of getting a stack trace from the point of the error?

possibly

> Also, which PG version is this?

12.3

It is probably relevant that we cleaned up roles & privs yesterday, lots of REVOKE & GRANT, and some DROP ROLE. I
startedout thinking I'd made a mistake with that, but now I'm starting to wonder if there's a bug I hit in some of that
whichfubar'd something in system catalog... 

Maybe also relevant that the original creator & owner of the schema (zoewang) was dropped after schema owner was
changedsrv_risk. (Likewise, changed ownership of tables in the schema...) 




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: privileges oddity
Next
From: Stephen Frost
Date:
Subject: Re: privileges oddity