Re: role with "CREATEDB" and "CREATEROLE" without effect on GUI

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of 
> Thomas Sondag
> Sent: 17 May 2006 10:20
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] role with "CREATEDB" and 
> "CREATEROLE" without effect on GUI
> 
> Hi,
> 
> I would like to create an admin account without "SUPERUSER" 
> rights to manage databases and users creations without risk.
> 
> SQL :
> CREATE ROLE admin WITH NOSUPERUSER CREATEDB CREATEROLE 
> INHERIT LOGIN ENCRYPTED PASSWORD 'mot_de_passe';
> 
> SQL under "admin" with psql :
> CREATE ROLE production WITH NOLOGIN;
> GRANT production TO admin;
> CREATE DATABASE production WITH OWNER = production;
> 
> Work fine.
> 
> But with PgAdmin I doesn't have acces to create role and 
> create database menu when I login with the admin account.
> 
> I suppose this is a bug ?

Yes, it is. A fix is in the pipeline...

Regards, Dave.