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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
