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

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

Scott Marlowe 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.
>

It was!

Thanks,
MIchele

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Murray Fox 2008-10-16 06:55:06 Re: Problems with Timezones in Australia
Previous Message Craig Ayliffe 2008-10-16 06:23:08 Problems with Timezones in Australia