sunshine-587009
SSCrazy Eights
Points: 8981
More actions
March 7, 2008 at 12:58 pm
#203935
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 ¤
Adam Angelini
Points: 8548
March 7, 2008 at 3:28 pm
#786960
we add ours to the sqlagentuserrole and sqlagentreaderrole in msdb. they are able to view jobs, but not control or change them unless they own them.
March 7, 2008 at 3:52 pm
#786966
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 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply