Re: Securing stored procedures and triggers

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: Securing stored procedures and triggers
Дата
Msg-id 873avrqd1p.fsf@suzuka.mcnaught.org
обсуждение исходный текст
Ответ на Re: Securing stored procedures and triggers  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
"Scott Marlowe" <scott.marlowe@gmail.com> writes:

> On 10/31/07, Douglas McNaught <doug@mcnaught.org> wrote:
>
>> The only bulletproof way to do this currently is to write all your
>> stored functions in C and load them as a shared library.
>
> Well, as I pointed out in my post, even that's not bullet-proof.  As
> long as decompilers / debuggers etc... exist, then compiling is just a
> small barrier to a good hacker.  The only way to win is not to play,
> i.e. keep the code in house.

Very true, I should have said "semi-bulletproof".  :)

In addition, the "interesting" parts of a C function would be the SPI
queries, which unless further obfuscated would be easily extractable
from the library using strings(1).

-Doug

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Replacing RDBMS
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Server's Locale