Tag Archives: security

Data Loss

Posted on March 4, 2013 by way0utwest

This piece was originally published in Database Weekly. Two words that no database administrator ever wants to put together are “data” and loss”. We go to great efforts to ensure that our SQL Server data is protected, backed up, available … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Data Loss

The Group Account

Posted on February 13, 2013 by way0utwest

Managing security for groups, allowing access is selective ways to different individuals is hard. However it’s also something that many DBAs do on a regular basis. We deal with the challenges of row level security and tying particular pieces of … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Group Account

Data Freedom and Regulation

Posted on February 11, 2013 by way0utwest

The HIPAA laws passed in the US to provide for better privacy an security of medical information seem to be a joke in many of the situations in which I’ve dealt with medical providers. It almost seems like signing a HIPAA acknowledgment form is … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Data Freedom and Regulation

Granting Permission to Grant Permissions

Posted on January 28, 2013 by way0utwest

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a view and you wanted to allow a user to grant permissions to this view to other users. It’s not a … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Granting Permission to Grant Permissions