Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
role with "CREATEDB" and "CREATEROLE" without effect on GUI

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 ?

Thanks

   Thomas


Home | Main Index | Thread Index

top