Build "selective firing" into your database triggers description
PL/SQL example with narrative that illustrates how to build "selective firing" into database triggers via an outermost, enclosing conditional that evaluates user ID.
File List:
@PSC_ReadMe_893_5.txt
1Kb
trigger_control.sql
3Kb
Similar code
Dynamic trigger
(Popularity: ) : Write business rules using conditions (T-SQL), message texts (plain text) and actions (T-SQL) and store them in a database table. These rules will be automatically called by a general purpose trigger generated dynamically by the Software. Disable a trigger for a specific user
(Popularity: ) : Okay, okay... "disable" is too strong a word. The trigger still fires, but it just doesn't do anything. Via the USER built-in PL/SQL function, you can easily bypass trigger activity for a user. This example shows how.
Code Library
) : Write business rules using conditions (T-SQL), message texts (plain text) and actions (T-SQL) and store them in a database table. These rules will be automatically called by a general purpose trigger generated dynamically by the Software.