Re: [BUGS] permissions denial to superuser with foreign keys

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] permissions denial to superuser with foreign keys
Дата
Msg-id 12118.1509738470@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] permissions denial to superuser with foreign keys  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
Jeff Janes <jeff.janes@gmail.com> writes:
> I thought superusers bypassed permissions checks, but was surprised where
> in this case they do not:

This amounts to asking for superuser permissions to propagate into
SECURITY DEFINER functions called by the superuser, which strikes me
as an utterly horrid idea.

(RI triggers aren't actually implemented with the SECURITY DEFINER
mechanism, but they act like they are.)
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: [BUGS] permissions denial to superuser with foreign keys
Следующее
От: vtap@club-internet.fr
Дата:
Сообщение: [BUGS] BUG #14887: initdb.exe seems to be infected by a virus