Jerry Sievers wrote:
Dayo Johnson <[EMAIL PROTECTED]> writes:Is it possible to do the following:Disallow permission to write to a table (either by UPDATE or INSERT) but allow EXECUTE permission on a Function that writes to the table ?Study up on the 'security definer' option in the manual sections on user defined functions. HTH
Thank you, I believe that sorts me out :-) Cheers DayoJ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend