pg_largeobject is a security hole

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pg_largeobject is a security hole
Дата
Msg-id 8703.993659269@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: pg_largeobject is a security hole  (Philip Warner <pjw@rhyme.com.au>)
Список pgsql-hackers
I propose that initdb should doREVOKE ALL on pg_largeobject FROM public
same as it does already for pg_shadow and pg_statistic.  This would
prevent non-superusers from examining or modifying large objects
except through the LO operations.

This is only security through obscurity, of course, since any user can
still read or modify another user's LO if he can guess its OID.  But
security through obscurity is better than no security at all.  (Perhaps
someday the LO operations will be enhanced to perform access-rights
checks.  I have no interest in doing that work right now, however.)
        regards, tom lane


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

Предыдущее
От: "Frank Ch. Eigler"
Дата:
Сообщение: Re: Re: Encrypting pg_shadow passwords
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: Encrypting pg_shadow passwords