Jerry Sievers wrote:
Dayo Johnson <dayoj@xxxxxxxxxxxxx> 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