Trigger with superuser privileges
Started by Tulio Oliveiraover 25 years ago2 messagesgeneral
Hi, all
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)
regards,
Tulio Oliveira
--
======================================================
AKACIA TECNOLOGIA
Desenvolvimento de sistemas para Internet
www.akacia.com.br
RE: Trigger with superuser privileges
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?