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 |
|
Blin
Starting Member
36 Posts |
 Posted - 2006-11-09 : 10:42:38
|
| I need to grant permissions to a developer so that she will be able to view and execute all jobs owned by a sysadmin login. But, I don't want to grant her sysadmin role. Are there any ways to do this so she can view and run the jobs not owned by her?Thanks, Ben |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-11-09 : 15:54:05
|
| Blin,Your question makes no sense. It's like "I want to let you drive my car, but I don't want to give you the keys."If you trust this developer enough to view and execute a sysadmin login's jobs, why can't you trust her enough to grant her a sysadmin role?Ken |
 |
|
|
Blin
Starting Member
36 Posts |
Posted - 2006-11-09 : 20:25:14
|
| Ken,Do you mean there is no other way but granting her sysadmin role? Ben |
|
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2006-11-10 : 02:27:40
|
| hheheheeh... yes... no other way...SlayerS_`BoxeR` + [ReD]NaDa |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-11-10 : 15:50:56
|
Ben,quote:
Do you mean there is no other way but granting her sysadmin role?
Yes. But you should not have any concern about doing that... As I said, if you trust her enough to exec sysadmin jobs, you should trust her enough to make her a sysadmin. If you don't trust her enough, she shouldn't be viewing/running sysadmin jobs.Quite simple, really. :-)Ken |
|
|
|
Blin
Starting Member
36 Posts |
Posted - 2006-11-11 : 05:52:14
|
| Ken,This was not a "trust" issue. It was a technicl issue. I granted her TargetServersRole and it worked. I didn't have to make her a sysadmin.Thanks for your input.Ben |
|
|
|
|
|
|
SQL agent jobs