Re: role with "CREATEDB" and "CREATEROLE" without effect on GUI
This is a discussion on Re: role with "CREATEDB" and "CREATEROLE" without effect on GUI within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> > -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto gadmin-support-owner@postgresql.org] On Behalf Of > Thomas Sondag > Sent: 17 May ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 08:25 PM
| ||||
| ||||
 Re: role with "CREATEDB" and "CREATEROLE" without effect on GUI > -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto  gadmin-support-owner@postgresql.org] On Behalf Of> Thomas Sondag > Sent: 17 May 2006 10:20 > To: pgadmin-support@postgresql.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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org      |
Linear Mode
