|
|
|
SSC Veteran
 
Group: General Forum Members
Last Login: Wednesday, June 03, 2009 2:42 PM
Points: 281,
Visits: 511
|
|
I have a user group that is db_owner in development. They cannot see any sql server agent jobs. how can I fix this without giving sa access. They were able to view this in sql 2000.
¤ §unshine ¤
¤ §unshine ¤
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 523,
Visits: 10,275
|
|
| have a look in BOL for sql agent database roles. there are 3 fixes roles (user, reader and operator), a user needs to be assigned one of these roles (or the equivalent rights) before they can see the sql agent node.
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, June 03, 2009 2:42 PM
Points: 281,
Visits: 511
|
|
i found the answer, I had to create a credential and a proxy. thank you though!
http://msdn2.microsoft.com/en-us/library/ms187901.aspx
:D
¤ §unshine ¤
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, April 07, 2009 1:03 PM
Points: 402,
Visits: 538
|
|
|
|
|
