Re: No select permission on a table but can query it

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: No select permission on a table but can query it
Дата
Msg-id dcc563d10810151305u3b5b0d25sb9a1658154b330e2@mail.gmail.com
обсуждение исходный текст
Ответ на No select permission on a table but can query it  (Michele Petrazzo - Unipex srl <michele.petrazzo@unipex.it>)
Ответы Re: No select permission on a table but can query it  (Michele Petrazzo - Unipex srl <michele.petrazzo@unipex.it>)
Список pgsql-general
On Wed, Oct 15, 2008 at 1:33 PM, Michele Petrazzo - Unipex srl
<michele.petrazzo@unipex.it> wrote:
> I think that this is a strange question, but: I need to revoke the
> select permission on a table, but I also need to leave, with a function,
> a user do a query on column.
> A real case can be that a user "test" cannot have the permissions for do
> a "select * from articles", but for do a "select has_article('an_article')"
> where has_article are:

Look up "security definer" for functions.

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

Предыдущее
От: "Richard Broersma"
Дата:
Сообщение: Re: Numbering rows
Следующее
От: Mark Morgan Lloyd
Дата:
Сообщение: Re: Numbering rows