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

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Michele Petrazzo - Unipex srl" <michele(dot)petrazzo(at)unipex(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: No select permission on a table but can query it
Date: 2008-10-15 20:05:51
Message-ID: dcc563d10810151305u3b5b0d25sb9a1658154b330e2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 15, 2008 at 1:33 PM, Michele Petrazzo - Unipex srl
<michele(dot)petrazzo(at)unipex(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Morgan Lloyd 2008-10-15 20:18:08 Re: Numbering rows
Previous Message Rodrigo Gonzalez 2008-10-15 20:05:20 Re: Get PG version using JDBC?