Just curious....
What, if I creat a before delete trigger, and depending on circumstences, I raise an exception? Wouldn't it keep record from deleting?

----- Original Message -----
From: Helen Borrie
To: firebird-support@yahoogroups.com
Sent: Monday, August 01, 2005 4:37 PM
Subject: Re: [firebird-support] How can I prevent DELETE/INSERT/UPDATE on a table


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





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links







[Non-text portions of this message have been removed]