Viewing 2 posts - 1 through 3 (of 3 total)
You can use the below command to open the symmetric key.
--Grant ViewGRANT VIEW DEFINITION ON SYMMETRIC KEY::SQLSymmetricKey TO [UserName]--Grant ControlGRANT CONTROL ON CERTIFICATE::SelfSignedCertificate TO [UserName]
September 14, 2021 at 12:22 pm
#3929424
Thanks, Winston Smith.
It works for me.
January 28, 2020 at 1:32 pm
#3720901