From: | CaT <cat(at)zip(dot)com(dot)au> |
---|---|
To: | Dayo Johnson <dayoj(at)cleanjohn(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Priviliges and Roles |
Date: | 2006-02-27 12:22:50 |
Message-ID: | 20060227122250.GG2905@zip.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Feb 27, 2006 at 12:09:48PM +0000, 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.
I'm no expert but check out triggers. That should allow you to whatnot
the data and fail/pass the insert or update.
See: http://www.postgresql.org/docs/8.1/interactive/triggers.html
--
"To the extent that we overreact, we proffer the terrorists the
greatest tribute."
- High Court Judge Michael Kirby
From | Date | Subject | |
---|---|---|---|
Next Message | Lane Van Ingen | 2006-02-27 13:31:45 | Re: pgStatTuple |
Previous Message | Andy Shellam | 2006-02-27 12:21:51 | Re: Priviliges and Roles |