From: | val(at)webtribe(dot)net |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | DML Restriction unless through a function |
Date: | 2004-06-30 12:21:00 |
Message-ID: | 20040630122127.9492A18332@cheetah.webtribe.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
We are writing an API of sorts and for various business logic
aspects, it is necessary that certain checks and sets of data
are processed through the database in a certain method. The use
of functions provides the ability to do this, but I would
definitely like to restrict access to the under lying tables.
If I revoke insert,update,delete privileges on a table, would
the user still be able to affect data manipulation through a
function? Is that another way of getting around this?
TIA
From | Date | Subject | |
---|---|---|---|
Next Message | Prabu Subroto | 2004-06-30 12:41:36 | mysql2postgres has no documentation? |
Previous Message | Leo Leo | 2004-06-30 12:02:56 | a few Questions about quoted variables in psql |