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
Thanks,
Layne