From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <thomas(at)microdop(dot)org>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: role with "CREATEDB" and "CREATEROLE" without effect on GUI |
Date: | 2006-05-17 10:45:33 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40138824F@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-05-17 15:38:32 | Re: role with "CREATEDB" and "CREATEROLE" without effect on GUI |
Previous Message | Thomas Sondag | 2006-05-17 09:19:34 | role with "CREATEDB" and "CREATEROLE" without effect on GUI |