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
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 tha
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 per
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 05:03
Jerry Sievers wrote:
Dayo Johnson <[EMAIL PROTECTED]> writes:
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 ?
Study up on the 'security definer' option in th
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
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 commerc
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 best
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:
>
>>
