[EMAIL PROTECTED] wrote:
Hi all;
Is it possible to write a trigger or the ilk that would disallow direct inserts, updates, or deletes to a table unless it was being executed through a function? How can I identify that the DML being issued is being done via a function?
http://www.postgresql.org/docs/7.4/static/sql-createfunction.html
Look for security definer. Grant table access only to user who creates the function and grant access to function to everybody concerned.
HTH
Shridhar
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
