March 7, 2008 at 1:18 pm
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 ¤
March 7, 2008 at 1:36 pm
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.
March 7, 2008 at 3:51 pm
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
😀
¤ §unshine ¤
March 9, 2008 at 11:17 pm
Refer the below link as well which describes the 3 roles available in msdb which John mentioned,
http://msdn2.microsoft.com/en-us/library/ms188283.aspx
[font="Verdana"]- Deepak[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply