[ADMIN] Priviliges and Roles

2006-02-27 Thread Dayo Johnson
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

Re: [ADMIN] Priviliges and Roles

2006-02-27 Thread CaT
On Mon, Feb 27, 2006 at 12:09:48PM +, 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

Re: [ADMIN] Priviliges and Roles

2006-02-27 Thread Andy Shellam
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

Re: [ADMIN] Priviliges and Roles

2006-02-27 Thread Bruno Wolff III
On Mon, Feb 27, 2006 at 12:09:48 +, 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