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 |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2006-12-03 : 20:51:27
|
| im trying to allocate a user appropriate permissions but i would like to see the users activities to make sure i do give that user exactly what they need how do i check user activity on sql server 2005 |
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2006-12-04 : 05:19:19
|
| Hi,You may need to run profiler with columnfilter dbusername like optionMadhu |
 |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-06 : 01:57:58
|
| expand the security folder,expand the logins folder and then right click oneach login and navigate diffrent options to see various permissions allocatedits me monty |
|
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-12-06 : 07:16:40
|
quote:
Originally posted by madhuotp
Hi,You may need to run profiler with columnfilter dbusername like optionMadhu
Theoretically, this would work only if you allocate SA rights to the user then monitor their activity then progressively remove unneeded rights. The other way around wouldn't work, unless if you are going to depend on the user to come to you every time they execute something and it gives them an insufficient rights error then upping their rights.RegardsNThe revolution won't be televised! |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-11 : 20:10:57
|
| if i do this:select * from dbname..SYSDEPENDS WHERE STATUS=0 AND DEPNUMBER = 0select * from sys.sysobjects where id = 112343552this then finds the objects details and ill check something here (maybe refdate) and if it hasnt been used for a year or two then move it somewhere else for now as its not used) |
|
|
|
|
|
|
SQL Server 2005 user activity