Re: Security Issues: Allowing Clients to Execute SQL in the Backend.

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Security Issues: Allowing Clients to Execute SQL in the Backend.
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17CF50D9@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на Security Issues: Allowing Clients to Execute SQL in the Backend.  (Hello World <worldanizer@gmail.com>)
Ответы Re: Security Issues: Allowing Clients to Execute SQL in the Backend.  (Hello World <worldanizer@gmail.com>)
Список pgsql-general
Hello World wrote:
> Given this are there any security other issues about letting client applications execute arbitrary SQL
> commands on the backend database?

There shouldn't be any security problems, just be careful that you don't give the
user more permissions than you want to.

But a user who can execute arbitrary queries can easily bring the system down:
You can write SQL queries that keep a CPU 100% busy, that exhaust disk space
and possibly memory.

Yours,
Laurenz Albe

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

Предыдущее
От: Hello World
Дата:
Сообщение: Security Issues: Allowing Clients to Execute SQL in the Backend.
Следующее
От: Hello World
Дата:
Сообщение: Re: Security Issues: Allowing Clients to Execute SQL in the Backend.