| From: | Joshua Brindle <joshua(dot)brindle(at)crunchydata(dot)com> |
|---|---|
| To: | Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Shinya Kato <Shinya11(dot)Kato(at)oss(dot)nttdata(dot)com>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Jeff Davis <pgsql(at)j-davis(dot)com> |
| Subject: | Re: CREATEROLE and role ownership hierarchies |
| Date: | 2022-01-04 20:47:31 |
| Message-ID: | CAGB+Vh4cCH5GtGGpTxMnhceC92ijQacF67uP5DRJcK8DFAE5+g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jan 4, 2022 at 3:39 PM Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> wrote:
>
>
>
> > On Jan 4, 2022, at 9:07 AM, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> wrote:
> >
> > No, that looks like a bug.
>
> I was able to reproduce that using REASSIGN OWNED BY to cause a user to own itself. Is that how you did it, or is there yet another way to get into that state?
I did:
ALTER ROLE brindle OWNER TO brindle;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-01-04 20:56:39 | Re: [PATCH v2] use has_privs_for_role for predefined roles |
| Previous Message | Tom Lane | 2022-01-04 20:42:07 | Re: psql: \dl+ to list large objects privileges |