Home > IT Answers > Database > Trigger for DB2 user administration
Meetamar1585
5 pts.
 Trigger for DB2 user administration
DB2 administration, DB2 Command Editor, 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

Software/Hardware used:
ASKED: February 21, 2009  9:18 AM
UPDATED: February 24, 2009  3:33 PM
RELATED QUESTIONS
Answer Wiki:
How to add a trigger <a href="http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/sqlp/rbafymstdb2triggers.htm">click here</a> If you dig further into this publication it gives you example of building trigger programs. Good luck. Kev
Last Wiki Answer Submitted:  February 24, 2009  3:33 pm  by  Kpassey   60 pts.
All Answer Wiki Contributors:  Kpassey   60 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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!

Technochic
 56,975 pts.