Post reply

AUTHORIZATION to open a SYMMETRIC KEY

  • February 9, 2007 at 7:49 am

    #172028

    I need to give rights to a set of users to open a specific SYMMETRIC KEY that I have created to encrypt some fields in one table.

    I have tried to AUTHORIZED a normal DATABSE ROLE but it does not allow me to do that. I can only AUTHORIZE one user or one application role.

    Please, where can I find documentation on the details of setting encryption with SQL 2005?

    Thanks.

     

     

     

     

     

  • February 9, 2007 at 8:23 am

    #688860

    you have to look no further than on this website

    SQL 2005 Symmetric Encryption

    http://www.sqlservercentral.com/columnists/mcoles/sql2005symmetricencryption.asp

    Everything you can imagine is real.

  • February 9, 2007 at 11:34 am

    #688935

    Thank you.

    I finally played with the security in Mgt Studio.

    We are encrypting the SYMMETRIC KEY with a CERTIFICATE.

    So...how I made it work was by creating a database role to which I gave CONTROL rights to the CERTIFICATE and VIEW DEFINITIONS rights to the key.

    Now any member of the role has the ability to open the symmetric key encrypt/decrypt and then close the symmetric key.

    And by the way thanks for the reference. That was my first reading for SQL 2005 encryption. Very good, clear and concise.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply