Re: Making "SECURITY DEFINER" procedures.. - SOLVED

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Making "SECURITY DEFINER" procedures.. - SOLVED
Дата
Msg-id 19603.1051675837@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Making "SECURITY DEFINER" procedures.. - SOLVED  (Sergey Holod <sss@radiocom.net.ua>)
Ответы Re: Making "SECURITY DEFINER" procedures.. - SOLVED
Список pgsql-sql
Sergey Holod <sss@radiocom.net.ua> writes:
> GRANT USAGE ON schema data TO rcbilling;
> Don't fully undestand why I need that, but It works..

Okay, that's the same bug we found just a couple days ago.  Schema-usage
errors are checked at query parse time, not execution time, and the
foreign-key triggers weren't being careful to set the right context for
those checks.  There's a fix in place for 7.3.3.
        regards, tom lane



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