What are the privileges required to execute a trigger function in PostgreSQL?
15
votes
1
answer
19612
views
What are the privileges required to execute a trigger function in PostgreSQL 8.4?
It seems that privileges set to a role do not matter when executing a trigger function. I think I have seen some day that the privileges required to execute a trigger function is the
EXECUTE
privilege but for the owner of the table, not the actual role that performs the action which fires the trigger that calls the trigger function.
I cannot find the documentation part that explains that point, any help?
Asked by user18077
Jul 23, 2013, 08:23 AM
Last activity: Apr 28, 2024, 06:35 PM
Last activity: Apr 28, 2024, 06:35 PM