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 ...

They are each split into several partitions: SYSTEM (the OS),DATA (Where SQL is installed), LOGS, and BACKUP. What would be appropriate permissions for these partitions? In particular what NTFS ...

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 ...

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?< ...

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 ...