In Postgres, how can I create a user that has CREATEROLE-privileges, but only for a specific DB/set of DBs?
I tried doing:
CREATE ROLE user WITH LOGIN PASSWORD 'password' NOCREATEDB CREATEROLE;
Is this correct? + How can I grant CREATEROLE to more than one db?