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 <[EMAIL PROTECTED]> 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!
>
>
>
- [ADMIN] Priviliges and Roles Dayo Johnson
- Re: [ADMIN] Priviliges and Roles CaT
- Re: [ADMIN] Priviliges and Roles Andy Shellam
- Re: [ADMIN] Priviliges and Roles Dayo Johnson
- Re: [ADMIN] Priviliges and Roles Bruno Wolff III