User Trigger

[craig322]

Has anyone written a trigger that will do something ONLY if a specific user is the person performing an action?

For example, I want to set up a trigger that if one person inserts a row into a table, that it will process that row. If anyone else inserts a row, it won't do anything.

Ideally this would be nice if it could actually look at specific roles and not users, but I can live with either.

TIA

 

[Abhivyakti]

hi

Yes you can do that. For that you have to write the when clause before the begin. You may trap the 'user' values to check if it is the user you want to track down. And when clause will make sure that this trigger , although it is on DML stmt on a particular table, it will still check the when clause to further restrict the execution of the trigger.

abhivyakti