Post reply

block dba access to user data

  • July 22, 2010 at 9:44 am

    #225248

    Is there a way in sql 2008 to block a dba's access to user data? I think the capability exists. however I cant seem to find any documentation on it.

  • July 22, 2010 at 9:53 am

    #1196951

    Is the DBA a sysadmin? If so, I do not know of any way to deny access for the DBA to access any DB in that instance

    -Roy

  • July 22, 2010 at 9:55 am

    #1196952

    i think sql 2008 had the capability to wall off any users including dbas from being able to see the data in the database.

  • July 22, 2010 at 9:58 am

    #1196953

    You can always add the DBA accounts to DenyDataReader/DenydataWriter groups and that would give you access denied errors, but then the DBA could simply remove themselves from that group.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply