Trigger Function DML and Permissions

From: Raymond <support(at)bigriverinfotech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Trigger Function DML and Permissions
Date: 2003-07-21 02:05:06
Message-ID: 200307201905.06885.support@bigriverinfotech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Appears Postgres 7.3.3 utilizes current user permissions when executing DML
within trigger functions.

How would one transparently (from the client perspective) switch users for the
purpose of trigger function execution and the restore to the original after
execution?

This issue will arise again with Insert, Update and Delete functions.

Raymond

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-07-21 02:10:20 Re: Datatypes and performance
Previous Message Bruce Momjian 2003-07-20 23:24:23 Re: PostgreSQL vs. MySQL