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