Re: Protection from SQL injection

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Protection from SQL injection
Дата
Msg-id 12890.1209229514@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Protection from SQL injection  ("Thomas Mueller" <thomas.tom.mueller@gmail.com>)
Список pgsql-sql
"Thomas Mueller" <thomas.tom.mueller@gmail.com> writes:
> SET ALLOW_LITERALS NONE;

I think you missed April Fool's Day...

This is just silly, as it makes life impossibly painful for users
(constants are hardly a useless part of SQL) and it doesn't really
plug any holes.  As an example:
select * from tab where intcol = intcol; delete from tab;

contains no literals and yet the delete is very probably injected.
        regards, tom lane


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

Предыдущее
От: "Thomas Mueller"
Дата:
Сообщение: Protection from SQL injection
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: Protection from SQL injection