No select permission on a table but can query it

Поиск
Список
Период
Сортировка
От Michele Petrazzo - Unipex srl
Тема No select permission on a table but can query it
Дата
Msg-id 48F64586.50407@unipex.it
обсуждение исходный текст
Ответы Re: No select permission on a table but can query it  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
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:

FUNCTION has_article (text) RETURNS articles AS $$
    SELECT * from articles WHERE id_article=$1;
$$ LANGUAGE SQL

Into my tries I receive always a
ERROR:  permission denied for relation articles

It's there a solution?

Thanks,
Michele

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

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