Re: Create DB privilege is not inherited

2023-07-27 Thread Ben Hancock
On Thu, 27 Jul 2023 06:09:28 -0700 "David G. Johnston" wrote: > On Thursday, July 27, 2023, Ben Hancock wrote: > > > > > > Should the CREATEDB privilege be inherited when granting the 'admins' > > role to a user, or is another step required? > > > > Or (quite possibly) have I misunderstood somet

Re: Create DB privilege is not inherited

2023-07-27 Thread David G. Johnston
On Thursday, July 27, 2023, Ben Hancock wrote: > > > Should the CREATEDB privilege be inherited when granting the 'admins' > role to a user, or is another step required? > > Or (quite possibly) have I misunderstood something else? > Docs say: https://www.postgresql.org/docs/current/sql-createrol

Create DB privilege is not inherited

2023-07-27 Thread Ben Hancock
Hi folks, I've created a role 'admins' and conferred the CREATEDB and CREATE ROLE privileges to this role. I'd like to be able to add users to this role in order to easily manage group permissions. This doesn't seem to be working the way I understand it should, though: postgres=# CREATE ROLE admi