Trigger for DB2 user administration
Home > IT Answers > AS/400 > Trigger for DB2 user administration
Meetamar1585
5 pts.
0
Q:
Trigger for DB2 user administration
DB2 Command Editor, DB2 administration, DB2 triggers
Hi guys....

Please help me....

I want to create trigger to avoid users updating records or when he update that data want to write one log file with his Login ID, time, date etc. please help me. If these is possible using trigger then pls tell me how ?

Thanks
Amar
ASKED: Feb 21 2009  9:18 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Kpassey
60 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
How to add a trigger

click here

If you dig further into this publication it gives you example of building trigger programs.


Good luck.

Kev
Last Answered: Feb 24 2009  3:33 PM GMT by Kpassey   60 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Technochic   40210 pts.  |   Feb 21 2009  5:49PM GMT

Can you help us provide an answer by providing us with more details please? What application or database is it you are asking about please? What version and patch level? Thanks!

 
0