Postgres CREATEROLE limit to specific db

Viewed 3732

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?

2 Answers
Related