> -Original Message-
> From: Thomas Sondag [mailto:[EMAIL PROTECTED]
> Sent: 22 May 2006 15:10
> To: Dave Page; Pgadmin-Support
> Subject: Re: role with "CREATEDB" and "CREATEROLE" without
> effect on GUI
>
> Hi,
>
> Same kind of problem with the role property editor, you are
> not
Hi,
Same kind of problem with the role property editor, you are not
allowed to modify ROLE properties.
I've got a very few understanding of pgadmin code (and no C++ skill at
all ) but this patch do the job.
Thomas
diff pgadmin3/src/dlg/dlgRole.cpp pgadmin3_1.4.svn20060522/src/dlg/dlgRole.cpp
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page
> Sent: 17 May 2006 11:46
> To: [EMAIL PROTECTED]; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] role with "CREATEDB" and
> &qu
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Thomas Sondag
> Sent: 17 May 2006 10:20
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] role with "CREATEDB" and
> "CREATEROLE" with
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 NO
