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  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: ed despard
Дата:
Сообщение: rules question
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Making "SECURITY DEFINER" procedures.. - SOLVED