SQL Server with Mr. Denny

May 4 2016   4:00PM GMT

When using Always Encrypted in SQL Server 2016, how do I as the DBA view the data?

Denny Cherry Denny Cherry Profile: Denny Cherry

Tags:
Data Encryption
SQL Server

The short answer is, you don’t.

The entire point of Always Encrypted is that the DBA can’t view or modify the data using SQL Server Management Studio. The only way to view and change the data is by using the front end application that created the data. This means that if someone submits a ticket to your team to change some data, you won’t be able to. You’ll have to refer that ticket back to someone in the business to have them make the change using the application just like a normal user would as you can’t touch the data.

Denny

2  Comments on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • ArmorDba
    That would be a major problem in my shop. I am asked to change data which the application does not handle. I agree all the data changes should be through the application but is that case in the real world. I think not.
    10 pointsBadges:
    report
  • SumOfDavid
    Then you should probably use the Sometimes Encrypted feature
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: