Re: privileges oddity - Mailing list pgsql-general

From Scott Ribe
Subject Re: privileges oddity
Date
Msg-id DA4A1A92-75A5-4DBE-AE71-33411213D112@elevated-dev.com
Whole thread Raw
In response to Re: privileges oddity  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: privileges oddity  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
> On Aug 7, 2020, at 12:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> If I'm reading this correctly, you have set things up so that any
> session logging in as akanzler will immediately do "SET ROLE
> confidential_read_only", after which it's the privileges of that
> role not akanzler that determine what happens.

YES, confidential_read_only has privs on everything *except* individual user's schemas, and rolinherit was accidentally
set,that would certainly seem to be the problem. But I turned that off, and it still doesn't work--even in a new
connection.




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: privileges oddity
Next
From: Adrian Klaver
Date:
Subject: Re: privileges oddity