Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-27 : 11:06:50
|
| Vijay writes "Team, I have a security related problem in sql 6.5.Is there any way to find out the db activities (like creation, deletion, updation of objects) made by a user(I mean a login user)My problem is, I have created a login and granted dbo rights to that login. It was given to one of my colleague. I just want to track the db activities he is doing using that login. (I am away on vaction).My manager dont want to give sa login. So, i planned this way.hope you understood my problem.Thanks." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-27 : 13:20:52
|
| Did SQL 6.5 have a Profiler like version 7 does? I didn't jump into the fray until v7. That might help if it exists.--------------------------------------------------------------1000 Posts, Here I come! I wonder what my new title will be...Edited by - AjarnMark on 12/27/2001 13:21:19 |
 |
|
|
MuadDBA
628 Posts |
Posted - 2001-12-27 : 16:40:58
|
| It does indeed. It was called SQLTrace. You set it up similarly to SQL Profiler, but /I am not sure if you can whittle down the fine detail like you can in SQL Profiler. Toy around with it though, as I am pretty sure you can set it to trace a specific user, and show only TSQL statements they use. I don't think it had the ability to save to a table, though, so make sure you have a BIG OL' load of disk space to hold all the information it will likely put out.I would give you more info myself, but we recently completely migrated to 7.0 and thus 6.5 is not installed on my PC anymore. |
|
|
|
|
|
|
Tracking user activities