THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Lara Rubbelke

Interesting Things in the World of SQL Server

SQL Server Separation of Duties Whitepaper Released

Hot off the virtual press, the SQL Server Separation of Duties Whitepaper is now available!  SQL Server 2008 R2 provides the full breadth of tools to support restrictive compliance and security requirements. This whitepaper will associate the features and options available in SQL Server 2008 R2 to meet the varying separation of duties requirements to enable the DBA to be productive and responsive while protecting applications and sensitive data.

Key concepts in the whitepaper are:

  • Applying Security Principles to the DBA (ie the DBA is NOT sysadmin!)
  • Protecting Database and Data Access
  • Authorizing Elevated Privileges for Specific DBA Task

I hope you enjoy the paper! :-)

Published Friday, May 6, 2011 12:17 PM by Lara Rubbelke



David Sorauer said:

Thanks for an interesting read! We have had similar requirements, and needed to create our own seperation of duties methodology (including security elevation tools) as it was very hard to find any established principles or documentation for SQL Server.

We have new audit requirements for DBAs to deploy scripts without having access to modify these scripts prior to deployment- have you seen a solution for this?



September 14, 2011 3:20 AM

Dirk Hondong said:

Hi Lara,

I wanted to take a look at the whitepaper but it seems that the downloadlink is broken. Is the doc available at another DL location?



November 18, 2011 7:02 AM

Lara Rubbelke said:

Hello Dirk,  Thank you very much for letting me know about the issue. The link should be fixed now.  I am sorry if it caused any inconvenience!

November 19, 2011 5:12 PM

Brian said:

Hello Lara, The link to the white paper does not work. I see in you last post you say it is fixed but I believe it is broken again.

Thank you,


April 3, 2012 2:28 PM

Lara Rubbelke said:

Thanks Brian.  They keep moving the paper:-(  I updated the link again...

April 18, 2012 3:09 PM
New Comments to this post are disabled
Privacy Statement