Re: privileges oddity

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: privileges oddity
Date: 2020-08-07 19:51:34
Message-ID: 999BA1C4-FBF8-4EE1-B866-67AD3B500116@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Aug 7, 2020, at 1:32 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Yes, you are. It looks like what you actually issued is
>
> ALTER USER akanzler SET role confidential_read_only;
>
> but that would have the effect that subsequent session starts would
> automatically do "SET ROLE confidential_read_only".

AHA! This is the correct answer, and it is solved now.

I *know* I executed grant role properly--it's right there in the script.

However, I think that SET ROLE had been accidentally misused instead of GRANT <role> at some point in the past, *AND* that the role contained privs to the user-specific schemas when it should not have. So revoking all privs from the role and adding back the proper ones resulted in inadvertently removing privs from users who'd properly had them explicitly granted.

(I've never even used SET ROLE and was unaware you could even do that!)

Anyway, thanks a million for being patient and sticking with this.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2020-08-07 20:29:29 Re: privileges oddity
Previous Message Adrian Klaver 2020-08-07 19:46:23 Re: privileges oddity