Re: grant problem

Rajarshi Mukherjee wrote:
> Hello all,
>
> i have a function that updates a table. I gave execute grant on it to
> a particular user but no grant on the table in question.
>
> when logging in as that user and executing the function, i get an error
> ERROR: permission denied for relation <table_name>
>
> How can i ensure that any update on this table is only done through
> that function, and that the function is oublicly executable?

Check the manuals for "CREATE FUNCTION" - particularly the section on
SECURITY INVOKER vs SECURITY DEFINER

--
Richard Huxton
Archonet Ltd