By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

A security issue

P: 8
Hi... We are trying to find a way by which we can capture the OS id of the user performing the updates on the. Can it be done through the database?

We had an issue that someone deleted one of the important data in our environment (Window 2003 server & DB2 V9 fix pak 3) but our logs only showed the id by which the DB was logged into by (We have given same id to every one as it is a development environment) and otherwise also all the apps running on it have a same id.

So, is there any way to do that??? (Maybe some column of syscat table)
Dec 14 '07 #1
Share this Question
Share on Google+
1 Reply


docdiesel
Expert 100+
P: 297
Hi,

if you gave the same DB2 logon id to the whole team, there's little help. Maybe, if diag level ist right, that there's logon information in your db2diag.log with TCP/IP source address. Or have a look into the window$ event logs. Anyway, you'll need to know when the data was deleted.

For future purposes, GRANT rights to groups and add the window$ users to them. That way you can get people to having to use their own user/passwd.

Regards,

Bernd
Dec 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.