> 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?
Look for security definer. Grant table access only to user who creates the
function and grant access to function to everybody concerned.
In response to
pgsql-general by date
|Next:||From: joseph speigle||Date: 2004-06-30 13:45:18|
|Subject: substring syntax with regexp|
|Previous:||From: Karam Chand||Date: 2004-06-30 12:50:41|
|Subject: SQLyog for PostgreSQL has been released|