I used Column Level Encryption to encrypt one of the columns in my SQL Server database. Now everytime I want to SELECT to see that encrypted data, I have to open the symmetric key to decrypt the column and then close it.
I want to a particular user or login to always view the encrypted data. Is it possible in Column Level Encryption, if yes, how?