role with "CREATEDB" and "CREATEROLE" without effect on GUI
require($_SERVER['DOCUMENT_ROOT']."/includes/top_config.php");
?>
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