July 18, 2014 at 1:32 am
Hi All,
I am using DB with SQL SERVER Authentication privilege. If something will go wrong , suppose delete records or drop table. so we can not find who has done such type of activity. Because for every user it will be showing same username. Is there any way to trace or script for tracing , so that I can find user with Host name with IP address .
Please help me on this.
Thanks
Arooj
July 18, 2014 at 4:27 am
we can not find who has done such type of activity. Because for every user it will be showing same username
Why's that?
July 18, 2014 at 4:48 am
Because by mistake some user will be deleted some records , if i try to trace so i coudnt because everyone is using same userid. for security puprose , i want to know the script which i can run through job and trace all the activity
July 18, 2014 at 6:57 am
I guess the real question here is why all users are using the same username. If it's through an application, presumably there's some type of login or other authentication mechanism, so you could use that to log the activity each person does to build tracking into the system.
If it's through SSMS, then everyone should be connecting with their own login, preferably a Windows login. Then again, if they're connecting via SSMS and you have a recurring accidental deletion problem, maybe they shouldn't be.
I don't know the exact details of your situation, so take that into account when considering my advice.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply