Re: [HACKERS] something smells bad

Поиск
Список
Период
Сортировка
От Alex Pilosov
Тема Re: [HACKERS] something smells bad
Дата
Msg-id Pine.BSO.4.10.10106061912480.9744-100000@spider.pilosoft.com
обсуждение исходный текст
Ответ на Re: [HACKERS] something smells bad  (Martín Marqués <martin@bugs.unl.edu.ar>)
Ответы Re: [HACKERS] something smells bad
Список pgsql-general
On Wed, 6 Jun 2001, [iso-8859-1] Mart�n Marqu�s wrote:

> OK, now I'm more then astonished!
> Why was I able to insert as martin then?
> Isn't it true (as the docs say) that when I execute a query over a view with
> rules, the rules (querys in the DO of the RULE) are executed with permssions
> of the owner of the rule (or the view? Any way, martin is owner of both) and
> not of the user that executed the query?

No. With both views and rules, the actions are executed as the user who
executed the query. I don't know if there are plans to allow the 'execute
as owner' for rules, right now this option only exists for the triggers.



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

Предыдущее
От: "Len Morgan"
Дата:
Сообщение: Re: "trigger"ing a procedure every X minutes
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: using create constraint trigger