|Subject||Re: [firebird-support] How can I prevent DELETE/INSERT/UPDATE on a table|
> >What can I do to prevent DELETE/INSERT/UPDATE on a table?Alternatively, raise an exception in the trigger and the changes will
> >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.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!