[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] pgStatTuple

2006-02-27 Thread Lane Van Ingen
No, I didn't see the README file. Thanks so much for the info, Michael! -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Friday, February 24, 2006 6:13 PM To: Lane Van Ingen Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pgStatTuple On Fri, Feb 24, 2006 at

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

[ADMIN] Security / Annoucements List

2006-02-27 Thread August Zajonc
Dear Postgresql friends, I'm curious as to what's the best way to get good notice of security issues and/or new version releases? I'm subscribed to the -announce list, but since the beginning of the year have received at least 10-20 messages through it. Most of these messages appear to be

Re: [ADMIN] Security / Annoucements List

2006-02-27 Thread Marc G. Fournier
Best thing to do is setup a filter looking for anything from @postgresql.org, since any release or security related issues will be posted from someone with that domain as their address ... On Mon, 27 Feb 2006, August Zajonc wrote: Dear Postgresql friends, I'm curious as to what's the

Re: [ADMIN] Security / Annoucements List

2006-02-27 Thread August Zajonc
Great idea. Thanks! Marc G. Fournier wrote: Best thing to do is setup a filter looking for anything from @postgresql.org, since any release or security related issues will be posted from someone with that domain as their address ... On Mon, 27 Feb 2006, August Zajonc wrote: Dear