On Tue, Mar 22, 2005 at 17:27:25 +0530, Rajarshi Mukherjee <[EMAIL PROTECTED]> 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?
You need to create the function with the security definer property. > > Please provide suggestions. > > Thanks & Regards, > Raj. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
