On Wed, Oct 15, 2008 at 1:33 PM, Michele Petrazzo - Unipex srl <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general