Re: [HACKERS] GRANT ROLE and triggers

2007-07-05 Thread Richard Huxton
Claudio Rossi wrote: Hello, I'm trying to write a trigger function which uses GRANT ROLE statement. Scenario is: I have a group role (let's call it A) which has not superuser privileges and I want to grant A membership to current user after an insert on a particular table, then revoke it after a

[HACKERS] GRANT ROLE and triggers

2007-07-04 Thread Claudio Rossi
Hello, I'm trying to write a trigger function which uses GRANT ROLE statement. Scenario is: I have a group role (let's call it A) which has not superuser privileges and I want to grant A membership to current user after an insert on a particular table, then revoke it after a delete on it; I writ