Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Security to Access Jobs

Status
Not open for further replies.

Lezza

Programmer
Apr 4, 2003
10
US
We have locked our databases down to certain user created database roles. Now our problem is that when the SQL user is placed in these roles, they are unable to see any jobs listed under SQL Agent. I've tried several predefined server roles but can't seem to locate a lowlevel one that will allow the users to check jobs. Anyone have any suggestions as to how I can do this?

Thanks,

Layne
 
The jobs are held in MSDB so you probably have to make sure the users have proper access to that database
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top