AUTHORIZATION to open a SYMMETRIC KEY

  • diogenes1331

    Default port

    Points: 1420

    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.

     

     

     

     

     

  • bledu

    SSChampion

    Points: 12335

    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.

  • diogenes1331

    Default port

    Points: 1420

    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 3 (of 3 total)

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