Home Forums SQL Server 2008 SQL Server 2008 - General Data in certain fields in a table needs to be encrypted and later on decrypted to be used in sp. What should be the appropriate data type that can be used so that the same column can hold both the encrypted form and decrypted form of data? RE: Data in certain fields in a table needs to be encrypted and later on decrypted to be used in sp. What should be the appropriate data type that can be used so that the same column can hold both the encrypted form and decrypted form of data?

  • August 19, 2014 at 2:51 pm

    #1739394

    Hi,

    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.

    Thanks

    Nisha.V