SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

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 kind of permissions would need to be set for that?< ...

it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this permission much easier ...

Learn More. ScriptLogic wants to simplify the process of handling database permissions with a new security offering aimed at companies running Microsoft SQL Server. With Security Explorer for SQL ...

policy templates for reporting on SQL Server permissions as required by the Payment Card Industry (PCI) and the Health Insurance Portability and Accountability Act (HIPAA); support for FIPS 140 ...