PLEASE GIVE ME AN EXAMPLE..
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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]