RE: Trigger with superuser privileges - Mailing list pgsql-general

From Edmar Wiggers
Subject RE: Trigger with superuser privileges
Date
Msg-id NEBBIAKDCDHFGJMLHCKIOEJMCCAA.edmar@brasmap.com
Whole thread Raw
In response to Trigger with superuser privileges  (Tulio Oliveira <mestredosmagos@marilia.com>)
List 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?


pgsql-general by date:

Previous
From: "Bryan White"
Date:
Subject: Insert where not duplicate
Next
From: "Mark Cowlishaw"
Date:
Subject: Re: extra spaces