Re: Priviliges and Roles

["Andy Shellam" <andy.shellam@xxxxxxxxxxxxxxxxx>]

Hi Dayo,

This is how I understand it, but I might be wrong:
I believe the user who is has permission to execute the function also needs permissions to perform the table writes.

Regards

Andy

Dayo Johnson

wrote: > Hello, > > 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 ? > > The reason I want to do this is so that I can perform certain checks on > the data that is being written before I allow it to be written. > > Cheers DayoJ > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > !DSPAM:14,4402ee2c160447970214199! > > >