| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Trouble with v16 new CREATEROLE semantic |
| Date: | 2024-02-15 19:58:28 |
| Message-ID: | Zc5s5KSHRI45YFaA@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Feb 15, 2024 at 06:07:51PM +0100, Dominique Devienne wrote:
> When I read about v16, I thought great, this fits our intent, a single "owner"
> ROLE with CREATEROLE which is limited to administering only the ROLEs it
> created itself. I've always been bothered by the mega-power of CREATEROLE. But
> now that we're actually trying to use it, I'm a bit worried. Can someone
> explain (or guess) what I'm missing here?
Well, have you read the PG 16 release notes?
https://www.postgresql.org/docs/current/release-16.html
You might also want to review my unreleased slide deck about users:
https://momjian.us/main/writings/pgsql/user.pdf
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-02-15 20:00:24 | Re: How to do faster DML |
| Previous Message | veem v | 2024-02-15 19:18:29 | Re: How to do faster DML |