Re: DML Restriction unless through a function

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: DML Restriction unless through a function
Дата
Msg-id 20040630135232.GA13891@wolff.to
обсуждение исходный текст
Ответ на DML Restriction unless through a function  (val@webtribe.net)
Ответы Re: DML Restriction unless through a function
Список pgsql-general
On Wed, Jun 30, 2004 at 13:21:00 +0100,
  val@webtribe.net wrote:
>
> If I revoke insert,update,delete privileges on a table, would
> the user still be able to affect data manipulation through a
> function?  Is that another way of getting around this?

If you use a security definer function where the function creator
has access to the table, but others don't then you can do that.
There are some issues if you start using such functions in views,
but for simple usage it will do what you want.

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