In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions.

Even if you could (I don't know specifically, server-wide permissions can be fine grained by right clicking on the server object and going to properties), there would be nothing preventing you ...

Ok, I'm trying to understand how to approach this.I need to design a personnel database.Employees can see all of their own records.Managers can see all of the info for the employees beneath them ...

Idera, a provider of application and server management solutions announced the availability of SQL secure 2.7, the latest version of a solution that helps DBAs improve security and ensure compliance ...