RE: Trigger with superuser privileges

From: "Edmar Wiggers" <edmar(at)brasmap(dot)com>
To: "Tulio Oliveira" <mestredosmagos(at)marilia(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: RE: Trigger with superuser privileges
Date: 2000-12-19 22:11:45
Message-ID: NEBBIAKDCDHFGJMLHCKIOEJMCCAA.edmar@brasmap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Anobody could tell-me how can I make a Trigger thats execute some things
> whith "postgres" superuser privileges (like INSERT INTO a table that the
> user logged in don't have access)

I think triggers should run with table-owner user permissions. That way you
could have a table owned by superuser, who then grants insert/update/delete
privileges to regular users.

But I'm not sure that's how things are done now. Anyone?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jie Liang 2000-12-19 22:22:34 Re: Help me for "DBI->connect failed: Sorry, too many clients already."
Previous Message Bryan White 2000-12-19 21:58:33 Insert where not duplicate