Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Encrypting a Database
- Thread starter ko
- Start date
There is no built-in method of encrypting the <i>stored data</i>, though you can encrypt the data as it is sent over the wire (the network packets), as well as the text of things like stored procedures.<br><br>You could make a stored procedure to encrypt/decrypt on the fly, and use that SP to access the data, but performance would be less than stellar. <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
- Thread starter
- #3
Thank you very much for the reply. But my question was related to encrypting/hiding the schema of the SQL Server 7.0 database(not the data that resides within the database). I know there are different techniques by which you can encrypt the data over the network.<br><br>I will appreciate if someone could help me out of this.
As foxdev says, there is no built-in method of encrypting your stored data, by which he means your schema as well. I had always felt that this was a feature and not a fault.... a bit like Open Source coding. <p> <br><a href=mailto: > </a><br><a href= home</a><br>
To some extent, you could use views; you'd grant rights to the views, and remove the rights from the tables. In this way, the users could see the structures of the views that you set up, but not the underlying base tables, thus allowing you to hide columns or even entire tables.<br><br>Its not exactly what you are looking for, but perhaps it would satisfy the business need that you have. <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question