MS-SQL: How to grant a user rights to view all jobs and run all SPs?

KAMAZON

Golden Member
Apr 4, 2001
1,300
0
76
www.alirazeghi.com
Hi Team, I'm not sure what level access this consultant needs! I've looked through the roles and it seems like DDLADMIN role might be appropiate but I don't want to just grant it to him without first asking you experts. What roles will allow me to do all of the things I listed in the title, but also remain secure? Thank you!