> >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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com