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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
