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

Episode Comments

Success! Your comment will be posted when the producer approves it.

Fans of This Show also Like

Special Offers from This Show

Coupons and promo codes at MevioOffers