Subject Re: [firebird-support] How can I prevent DELETE/INSERT/UPDATE on a table
Author Helen Borrie
At 04:55 PM 1/08/2005 +0300, you wrote:
>What can I do to prevent DELETE/INSERT/UPDATE on a table?
>I suspect a trigger will be involve, but...

Not really. By the time a trigger fires, the operation is already under
way, i.e. allowed.

Use privileges. Assign the desired set of restrictive privileges to a
role; then assign that role to the users you want to restrict.

./heLen