YOUR CHANNEL IS LOADING

LATEST EPISODES MORE EPISODES

  • 1

    Encryption in Production

  • 2

    API Changes

  • 3

    Morale Data

  • 4

    Healthy Work Habits

  • 5

    No Cloud for Stack Exchange

The Voice of the DBA Administering Securely

MEVIOtoday

Jul 06, 2009 Administering Securely

The other day I noticed a post where someone was asking a question that I've seen asked often. I still haven't seen a great solution, and I expect this question will continue to be asked for some time to come. The poster asked how to securely set up a database to prevent administrators from accessing the data.

Prior to SQL Server 2005 this was pretty much impossible. The sysadmin group was considered to be like a god inside the SQL Server and could access most anything. With 2005 there are more restrictions you can place on the administrator, and with the addition of encryption capabilities, you can prevent casual access to certain data.

Read the rest of Administering Securely at SQLServerCentral.com