I created Master Key,Certificate and Symmetric Key.
Both Encrypt and decrypt works fine.But the issue is though the View definition on symmetric key is granted only to me,other users also are able to decrypt the data by opening the symmetric key .
How to restrict this. ?
PS : Decryption access is given only to me.But even then , all other users are able to decrypt the data.
How to restrict this and what would be the cause for this ?
GRANT VIEW DEFINITION ON SYMMETRIC KEY::symkey to [domain\abc]
GRANT VIEW DEFINITION ON CERTIFICATE::Certific to [domain\abc]
GRANT CONTROL ON CERTIFICATE::Certific to [domain\abc]
Any help will be appreciated.