Re: Disallow SET command in a postgresql server

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Disallow SET command in a postgresql server
Дата
Msg-id CAHyXU0yU6uT-muKBzOFs3L+14LJdH38kz6cWAoPLQ2fdwwL3zQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Disallow SET command in a postgresql server  (Fabio Rueda Carrascosa <avances123@gmail.com>)
Ответы Re: Disallow SET command in a postgresql server
Список pgsql-general
On Tue, Apr 9, 2013 at 10:57 AM, Fabio Rueda Carrascosa
<avances123@gmail.com> wrote:
> My grant/revoke architecture is fine, you mean about costly cpu/ram queries?

it has nothing to do with grant/revoke.   There are multiple trivial
things a user can do to DOS you server.  You can prevent a lot of
them, but it's definitely whack-a-mole.  If you don't believe me, try
logging into schemaverse in the next few moments.  I just took it
down.  It will come up shortly.

The only way I will advise opening up database to untrusted user is
through pgbouncer (modified to allow only v3 parameterized queries
that match a whitelist).

merlin


В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Disallow SET command in a postgresql server
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Disallow SET command in a postgresql server