Hi, ALL
This is my first time in this list... Sorry by any inconvenience....
I need a TRIGGER thats runs whith POSTGRES permissions. I�ll give an ODBC
connection for programmers that don�t need to know the "rules" of my Data
Base.
So, I�ll creata an "fake" table, and with a BEFORE INSERT TRIGGER I�ll make
all consistences, and update the REAL tables.
The ODBC users have only INSERT permission on the fake table, and NO RIGHTS
on the real table.
I�ll make VIEWS whith SELECT, UPDATE and DELETE permissions for the ODBC
users.
By the same way, I�ll make TRIGGERS that manager the VIEWS.
-----------
ALMOST ALL THIS WORK FINE when the function of the trigger is in PLPGSQL, but
in this language, the Trigger run with the same ODBD user�s rights ....
I read that only a "C" function runs with POSTGRES permissions, but all the
samples I get don�t work... I can�t even compile them...
Please, anyone could help an "poor brazilian guy" to make this work :-) ?
I appreciate any "C" Function complete samples, including de command line for
the compiler.
I using a RedHat Linux 6.2 and Postgresql 7.0.2-2
Best Regards,
Tulio Oliveira.
