On Tue, Mar 22, 2005 at 17:47:48 +0530, Rajarshi Mukherjee <[EMAIL PROTECTED]> wrote: > PLEASE GIVE ME AN EXAMPLE..
Please read the documentation of the CREATE FUNCTION command. > > > On Tue, 22 Mar 2005 06:24:58 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > 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 7: don't forget to increase your free space map settings
