467,917 Members | 1,342 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

Protecting .net dll's in Sql Server

dear friends

optimistically I'll suicide this weekend or my eyes going blind with sql exception's RED color;

my problem is :
I want to encrypt some of my columns in database and use "decryption.dll" to decrypt them.
the important point is I have to obfuscate the "hash key" string;

my problemS:
1.the CLR dose not support obfuscated dlls;

2.I tried to use assembly class to open decryption.dll and invoke those methods in other class library , but assembly loading is not permitted by CLR

3.I tried to use ObjectHandle class to Load the decryption.dll but I found the strange security permission exception , and "Larry Page" did not help me with his website.

4.I tried to add new class library and add reference to "decryption.dll" but the redline appears like : "which is not present in the current database ....."

Now , Please just help me to find a solution to Protect My "hash key".

thank you.
Jan 24 '09 #1
  • viewed: 2145
3 Replies
Expert 2GB
Would this work? You can use it and create a function. Let the key be inside your function and just return T or F if it's properly decrypted. You can ENCRYPT the code by using the WITH ENCRYPTION during the creation of your function.

Just an option....

-- CK
Jan 25 '09 #2
dear ck9663
thank you for your replay,

my application will install on client servers.
your solution just support "IsEqual" method , and I can do it in application like this :

Expand|Select|Wrap|Line Numbers
  1. select * from [table] where password = 'ckmbniwyr872tasdbcu34'
but I am looking for code like this

Expand|Select|Wrap|Line Numbers
  1. select * from [table] where dbo.decodeMethod.contain(firstname,'lwjdf3982acxkjh') = true
thank you.
Jan 25 '09 #3
Expert 2GB
I think that would be a .Net question. Have you tried posting this question in .Net forum?

-- CK
Jan 26 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

22 posts views Thread by Harold Crump | last post: by
12 posts views Thread by Roland Hall | last post: by
5 posts views Thread by John | last post: by
7 posts views Thread by Shawn | last post: by
9 posts views Thread by Lucas | last post: by
2 posts views Thread by Ryan Moore | last post: by
3 posts views Thread by Mike Kingscott | last post: by
1 post views Thread by =?Utf-8?B?S2xhdXMgSmVuc2Vu?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.