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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2004-08-04 : 08:25:39
|
| I have a few proggramers in my firm. They connect to server with login 'prog' (not 'sa'). I don't want to give them sysadmin rights, because I don't want to allow them to CREATE, ALTER, DROP, DETACH, ATACH, BACKUP, RESTORE ... DATABASE, and some other things (sp_addlogin, sp_password, ...).They have db_owner role for one of few database we have, with all permissions on the objects of that database. But, they can not use SQL-Profiler wich is a poweful for them to manage theirs applications, because they are not member of sysadmin role.How can I avoid that.Can I give them sysadmin rights, but to exclude some privileges.Or, what to add, to be able to use SQL Profiler, without sysadmin rightsThanks for any help |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-04 : 09:03:09
|
| Unfortunately, I don't think there's anything you can do. Profiler requires system administrator privileges as it can access all aspects of a server, but programmers cannot be system administrators with excluded privileges. Use of the profiler remains the privilege of you, the DBA.Raymond |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-04 : 09:22:50
|
| altough i suggest that those programmers that have contact with database have access to the profiler. it saved me a lot of time to have the profiler looking what's going on. Go with the flow & have fun! Else fight the flow :) |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-13 : 11:30:58
|
| i agree with raymond, profiler is process intensive and just imagining a couple of programmers running profiler at the same time can be a nightmare not to mention providing them with sysadmin privileges on a production server. |
|
|
|
|
|
|
|
|
Problems with login