| Author |
Topic |
|
malik_1700
Starting Member
14 Posts |
 Posted - 2008-09-22 : 04:10:10
|
| I have developed a store procedure,saved it to .sql file .This file has to be send to a user.I want to encrypt its code without using ENCRYPTION clause.because if I may or may not use the encryption, then for the first time the user can see the coding .Is there is any third party tool or solution that when user executes this file he should not b able to see the coding ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-22 : 04:15:08
|
| didnt understand that. Why do you want to encrypt without using ENCRYPTION? |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-22 : 04:49:08
|
| trywww.activecrypt.comhttp://www.quest.com/toad-for-sql-server/ |
|
|
|
malik_1700
Starting Member
14 Posts |
Posted - 2008-09-22 : 05:10:00
|
quote:
Originally posted by afrika
trywww.activecrypt.comhttp://www.quest.com/toad-for-sql-server/
I want to hide code so that user can't see coding.When script file is send to user , he can see codingIf I use ENCRYPT clause then when user will execute script he can see coding in sp. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-22 : 06:40:38
|
quote:
Originally posted by malik_1700
quote:
Originally posted by afrika
trywww.activecrypt.comhttp://www.quest.com/toad-for-sql-server/
I want to hide code so that user can't see coding.When script file is send to user , he can see codingIf I use ENCRYPT clause then when user will execute script he can see coding in sp.
didnt understand how he will see code if you encrypt it? |
|
|
|
malik_1700
Starting Member
14 Posts |
Posted - 2008-09-22 : 07:11:01
|
quote:
Originally posted by visakh16
quote:
Originally posted by malik_1700
quote:
Originally posted by afrika
trywww.activecrypt.comhttp://www.quest.com/toad-for-sql-server/
I want to hide code so that user can't see coding.When script file is send to user , he can see codingIf I use ENCRYPT clause then when user will execute script he can see coding in sp.
didnt understand how he will see code if you encrypt it?
Code is not encrypted.I explain it as following steps(1) CREATE PROCEDURE pprocedure is created in my db and coding is saved in a text file (script file)(2) This file is send to user to run so that store procedure is installed in user database.(3) When this file will b send to user , user can see the coding of store procedureso is there any solution in SQL SERVER 2000 to encrypt it into unreadable form so when user received it can't read its coding |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-22 : 08:41:52
|
| In 2000 ?I never heard of that. |
|
|
|
malik_1700
Starting Member
14 Posts |
Posted - 2008-09-22 : 22:26:35
|
quote:
Originally posted by afrika
In 2000 ?I never heard of that.
In 2005 or 2008 ? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-22 : 23:06:30
|
What you want is not possible. Maybe you can create an executable and send that over together with your encrypted Source text file. The executable will decrypt it and create it in the target database.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-22 : 23:22:32
|
| We purchased a software that runs with a web installer which does all the installation for us. |
|
|
|
|
Encryption