| Author |
Topic |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2009-06-16 : 12:32:45
|
| I have built a small properitary database and I want to encrypt the stored procedures, views, udf when i deploy it to another machine.I see that using "with encryption" clause is not 100% foolproof.Is there any other way to do it or any free third party softwares that does the job. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-16 : 15:05:07
|
| http://www.sqlservercentral.com/articles/Security/freeencryption/1980/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-16 : 15:13:38
|
Visakh, he doesn't want to encrypt the data, but the code for views, sp and functions.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-16 : 15:14:16
|
Maybe this is possible with database encryption, with sql server 2005 and later?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2009-06-17 : 12:41:06
|
| I see even sql server 2005 provides options to encrypt data not sps,udf's...If I am wrong, please provide additional info. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 12:45:42
|
| http://www.sqlservercurry.com/2008/02/how-to-encrypt-stored-procedure-in-sql.html |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2009-06-17 : 13:02:43
|
| "with encryption" clause is not reliable. It can be easily decrypted. I am looking for other options. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 13:18:30
|
quote:
Originally posted by cognos79
"with encryption" clause is not reliable. It can be easily decrypted. I am looking for other options.
can i ask why you need to encrypt body of procedure/ you can always restrict users from getting code by giving them only restricted permissions |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2009-06-18 : 13:23:53
|
| I am building a small database and when I sell it other people I do not want them to access the code. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-18 : 14:17:02
|
The SQL Server DBA will always have full access to the database.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2009-06-18 : 14:23:59
|
| Is it possible to give db to the client by revoking access to stored procedures? |
|
|
|
|
encrypting stored procedures