| From: | brichard(at)cafod(dot)org(dot)uk (Bruce Richardson) |
|---|---|
| To: | Tulio Oliveira <mestredosmagos(at)marilia(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Trigger and Permissions |
| Date: | 2001-02-26 22:57:04 |
| Message-ID: | 20010226225704.A13399@usb.cafod.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Feb 26, 2001 at 03:04:18PM -0300, Tulio Oliveira wrote:
> THE QUESTION::::
>
> How can I make a trigger that insert data in a table that no normal user
> have INSERT PERMISSION ?
While connected to the database as superuser, create a view of the log
table. Then create an insert rule so that when someone inserts a
record into the view the rule inserts the record into the log table.
Give your users permission to insert into the view.
This will work because rules act as if they were run by the person who
*owns* the view/table that the rule is tied to and *not* the person who
is actually logged in.
--
Bruce
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben Leslie | 2001-02-27 01:11:02 | Correct behaviour of "DROP DATABASE" |
| Previous Message | Norman J. Clarke | 2001-02-26 22:31:05 | Re: avoiding endless loop in an UPDATE trigger |