Re: [GENERAL] What is unsecure postgres languages? How to disable them?

Поиск
Список
Период
Сортировка
От dipti shah
Тема Re: [GENERAL] What is unsecure postgres languages? How to disable them?
Дата
Msg-id d5b05a951002220934x3e352c8em7c84334e4710826a@mail.gmail.com
обсуждение исходный текст
Ответ на What is unsecure postgres languages? How to disable them?  (dipti shah <shahdipti1980@gmail.com>)
Список pgsql-novice
Sorry Albe for confusion. Yes, I meant untrusted languages like C, PL/PerlU, PL/PythonU etc...

Thanks a lot you and Tino for nice reply. Could you guys tell me how could I verify whether those languages are installed on my PostGreSQL server?

Thanks for being there,
Dipti

On Mon, Feb 22, 2010 at 8:14 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
dipti shah wrote:
> Could anyone please tell me what is unsecure postgres
> languages(like C, pgperl, pgpython??). How to disable them or
> restrict them only for super user?

I have never heard of "unsecure" languages - what exactly do you mean?

If you mean "untrusted" languages like PL/PerlU, they are not
installed by default *and* they are restricted to superusers.

You cannot disable C functions, but to define them you must also
have superuser privileges.

Yours,
Laurenz Albe

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

Предыдущее
От: Marco Maggi
Дата:
Сообщение: Re: which mailing list for bindings writers
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] SET Role doesn't work from Security Definer Function...