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

From: "Thomas Sondag" <thomas(dot)sondag(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: role with "CREATEDB" and "CREATEROLE" without effect on GUI
Date: 2006-05-17 09:19:34
Message-ID: 2354aa530605170219r185a194id545a50d92315ab7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 ?

Thanks

Thomas

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-05-17 10:45:33 Re: role with "CREATEDB" and "CREATEROLE" without effect on GUI
Previous Message Hank Hsiung 2006-05-17 09:04:56 autovacuum?