You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

Say there are 1000 Windows users in a group called Accounting. To enable access to your SQL Server for those 1000 Windows users requires a single Windows login based on the Accounting group.

Hoping to pull from the hive mind on this one. I'm wondering if there is a way for someone to be able to do maintenance work on a sql server without actually being able to look at the data. What ...