Re: Trigger execution role - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: Trigger execution role
Date
Msg-id m24nu1fmfm.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: Trigger execution role (was: Triggers with DO functionality)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:
> This might be something to consider in the adjacent thread about command
> triggers, too --- who do they run as, and if it's not the calling user,
> how do they find out who that is?

As of now, calling user (we just calling a function), or another user if
the function is SECURITY DEFINER. Also, the current patch makes command
triggers superuser only.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: logging in high performance systems.
Next
From: Misa Simic
Date:
Subject: Pg 9.2 extension install