Securing the Data of Tables

Securing the Data of Tables

• c.barca

  What do you want to prevent exactly

  Are you trying to prevent someone from reading your data

  - can be done by encryption

  Are you trying to prevent modification of data that would corrupt it

  - cannot be done

  Are you trying to prevent modification of data such that it continues to appear as valid

  - can be done using an authenticating value to tie encrypted data to some other information (see the example I posted at http://blogs.msdn.com/lcris/archive/2005/06/10/428178.aspx, that tied the encrypted salary to the employee ID)

  Hope this helps

  Thanks
  Laurentiu

  
  
  

• csharpkid

  Hi Kebians,

  that depends wheter you use SQL Server 2005 (which has a built-in encryption) on a certificate basis or you use sql2k where you need additional third party tools that can implement encrypting the data on the server or at the client.

  HTH, Jens Suessmeyer.

  
  

• aslanky

  Thanks for the replies guys.

  I have heard abt some Hash Rule. But not clear abt it. Some one told me that hash rule hepls 2 protect data from other users. I am not sure but someone told me we can only view the data but can't change till we provide some fixed code to a column which is calculated as per user. I am not sure but heard only abt Hash Rule . So if u guys have idea plz suggest me.

  
  
  

• Marvin Hassan

  You can't prevent a dba from changing data in a database. You can protect data from the dba by encrypting it, but the dba could still drop the data or corrupt it.

  Thanks
  Laurentiu

  
  
  
• Securing the Data of Tables