Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> writes:
> I thought that if user 'test' was in group 'admins' and I specified INHERIT then it'd inherit those permissions?
No, inheritance of permissions only works for GRANT-able permissions;
the special role properties like CREATEDB are outside that scope.
I think though that if test does "SET ROLE admins" then she'd be
able to create a database.
regards, tom lane