Subject Re: [firebird-support] How can I prevent DELETE/INSERT/UPDATE on a table
Author Martijn Tonies
> >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.

Alternatively, raise an exception in the trigger and the changes will
be cancelled.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!