I'm configuring a multi-tenant PostgreSQL server. When I create a new
database, anyone can connect to it. For me, that is bad.
REVOKE CONNECT ON DATABASE d FROM public;
Now I'm only able to connect to the database as postgres.
I tired putting the create and revoke in a transaction, but create
database cannot be put in a transaction. How do I create a database so
there is not that nanosecond window where someone could connect to the
Alan Gutierrez - http://twitter.com/bigeasy - http://github.com/bigeasy
pgsql-novice by date
|Next:||From: Francisco Leovey||Date: 2011-05-27 23:05:20|
|Subject: Re: Revoke Public Database Connect|
|Previous:||From: Chetan Suttraway||Date: 2011-05-27 09:58:18|
|Subject: Re: How to recover from base|