Re: privileges oddity

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: privileges oddity
Date: 2020-08-07 19:27:26
Message-ID: 997A0678-B203-432F-AF7D-7ADB6415C28A@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Aug 7, 2020, at 1:08 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> "Using this command, it is possible to either add privileges or restrict one's privileges. If the session user role has the INHERIT attribute, then it automatically has all the privileges of every role that it could SET ROLE to; in this case SET ROLE effectively drops all the privileges assigned directly to the session user and to the other roles it is a member of, leaving only the privileges available to the named role. On the other hand, if the session user role has the NOINHERIT attribute, SET ROLE drops the privileges assigned directly to the session user and instead acquires the privileges available to the named role.
> "

So it would only have removed privs if I had used set role in the session, which I am not.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-08-07 19:32:03 Re: privileges oddity
Previous Message Adrian Klaver 2020-08-07 19:08:00 Re: privileges oddity