Data Encryption

  • Hi All - can data be encrypted at the column level with SQL 2000? I've looked for this info and it appears that you cannot. Please tell me I'm wrong

    It is easy to encrypt a view or stored procedure but it is also very easy to break this encryption. The situation is that the application group does not want the DBA's to have the ability to look at their data. Since they have sysadmin, encrypting a view or proc won't stop them. We do have tracing setup for all sysadmin activity but this is an "after the fact" control and they want a preventative control.

  • That type of encription has to be performed on the application layer not on the DB. Be careful because sometimes it has some undesired effects

    hth


    * Noel

  • Yup. If they don't want DBAs to see the data, it needs to be encrypted before it hits SQL Server.

    K. Brian Kelley
    @kbriankelley

  • Thank you both for your responses. This is what I had assumed but wanted to be sure.

  • Go to the site's search page at http://www.sqlservercentral.com/search/turbo.asp and look for 'encrypt'.  There's a lot of hits that might steer you in a productive direction.  I thought there was a recent review of a very serious encryption product for SQL Server, but I'm not seeing a link to it so it might have been on another site.

    But a previous poster was right, it's a delicate thing to work with.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • Of course I find it an hour later.   http://www.sqlservercentral.com/columnists/dcorey/netlibencryptionizerreview.asp

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 6 posts - 1 through 5 (of 5 total)

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