encryption - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

encryption

Author

Topic

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-04-04 : 04:42:56

hi all,
ive download some application, but they encrypt their Stored Proc and some Views..
1.how to encrypt SP?
2.is it possible to decrypt whateva that encrypted?

~~~Focus on problem, not solution~~~

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-04 : 04:45:16

There are some tools available for deencrypting SQL stored procedure and functions.
Feel free to Google them.

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-04 : 04:46:17

1. You can encrypt your SP by adding WITH ENCRYPTION clause while creating/altering SP/view/UDF
2. No. you can not decrypt an encrypted SP/View/UDF. You should have original plaintext version before doing encryption.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-04-04 : 04:58:13

harsh,

in my SP code here where should i put the WITH ENCRYPTION ?


CREATE PROCEDURE  SP_StageAutoPick

(	
-- my params
	@JobID VARCHAR(12),
	@DocRefID VARCHAR(12),
	@Shipper varchar(20),
	@ItemID varchar(50),
	@CustomLotNo VARCHAR(20),	
	@WantedValue INT
)
AS
BEGIN
--my code
END

~~~Focus on problem, not solution~~~

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-04 : 05:00:25

[code]

CREATE PROCEDURE SP_StageAutoPick

(
-- my params
@JobID VARCHAR(12),
@DocRefID VARCHAR(12),
@Shipper varchar(20),
@ItemID varchar(50),
@CustomLotNo VARCHAR(20),
@WantedValue INT
)
with encryption
AS
BEGIN
--my code
END
[/code]

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-04 : 05:03:49

Note you can't decrypt it. So always save your stored procedure / functions / views etc scripts in a file.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-04 : 05:03:59

192 posts and still don't know how to use Books Online for information about "WITH ENCRYPTION".

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-04 : 05:07:09

quote:
Originally posted by Peso

192 posts and still don't know how to use Books Online for information about "WITH ENCRYPTION".

Peter Larsson
Helsingborg, Sweden

Can't blame the OP, you spoon feed too much

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-04 : 05:11:55

Yes, you can decrypt an encrypted SP/UDF/VIEW.
It was easier in SQL Server 2000 than in SQL Server 2005.

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-04 : 05:36:47

quote:
Originally posted by Peso

Yes, you can decrypt an encrypted SP/UDF/VIEW.
It was easier in SQL Server 2000 than in SQL Server 2005.

Peter Larsson
Helsingborg, Sweden

Is it still possible to decrypt with 2005 ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-04 : 05:46:41

Orbital claim they can.
http://www.orbitaltechnologies.org/decryptor/

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-04 : 06:34:41

Are we suppose to post these information here ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-04 : 07:43:56

Depends on how you intend to use the information.
For your own personal use?
For breaking other people's code?

Peter Larsson
Helsingborg, Sweden

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2007-04-04 : 10:31:41

SQL Server's encryption has never been strong, and cracking scripts have been available for years. I don't think posting that link is going to make a difference one way or another.

e4 d5 xd5 Nf6

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-04 : 11:13:16

Pre-2005 I think they used same encryption principle as Office, which was extremely weak.
I haven't had the time to investigate SQL 2005 yet.

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-04 : 11:32:36

What I heard before releasing of 2005, is the encryption in 2005 is un-breakable. Looks like it is proven wrong.

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-04-04 : 21:09:16

WHAT?/ the encryptor cannot decrypt the code he encrypted?
this is chaotic.. ive encrypted one of my Sp for testing.. and now.. couldnt decrypt it?? huwa.. if only i read khtan post earlier.. :(

btw peso..

quote:
192 posts and still don't know how to use Books Online for information about "WITH ENCRYPTION".

192 posts from newbie doesnt count.. plus.. i sometimes fall asleep reading the BOL.. so why not get faster answer :P/.. plus when i search for the keyword it lists down too many things.. and i fall asleep while looking for the correct topic... plus i thought i jumpe into "NEW to SQL" (considering myself as a new user, probably 6 months experience :( )

~~~Focus on problem, not solution~~~

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-04-04 : 21:15:37

quote:
Originally posted by maya_zakry

WHAT?/ the encryptor cannot decrypt the code he encrypted?
this is chaotic.. ive encrypted one of my Sp for testing.. and now.. couldnt decrypt it?? huwa.. if only i read khtan post earlier.. :(

btw peso..
quote:
192 posts and still don't know how to use Books Online for information about "WITH ENCRYPTION".

192 posts from newbie doesnt count.. plus.. i sometimes fall asleep reading the BOL.. so why not get faster answer :P/.. plus when i search for the keyword it lists down too many things.. and i fall asleep while looking for the correct topic... plus i thought i jumpe into "NEW to SQL" (considering myself as a new user, probably 6 months experience :( )

~~~Focus on problem, not solution~~~

So basically, you're just too lazy to read Books Online?

CODO ERGO SUM

maya_zakry
Constraint Violating Yak Guru

379 Posts

Posted - 2007-04-04 : 21:31:57

umm..yup sometimes,, especially when i need that answer faster. and human answer better than books

~~~Focus on problem, not solution~~~

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-04-04 : 23:35:13

ridiculous.

if you are too lazy to find the answer in BOL yourself, use google to help you. just add "msdn2" to whatever phrase you need help with. Generally the first result will be the one you want. That's faster than posting here, and more importantly, it will make you more self-reliant.

for example: http://www.google.com/search?q=msdn2+encryption+stored+procedure

www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources