December 11, 2014 at 8:00 am
I have a following situation.
1. I need to encrypt set of strings in t-sql. These encrypted strings will be manually delivered to users.
2. Users have neither knowledge nor access to sql server. I'd like them to go to a website copy/paste the hash and get the original string.
- There are no security requirements. Just that the hash doesn't look like original string
- On the other hand it's important that access to the website and decrypting process is ultra-easy for the users.
- Do you know what t-sql function I can use(it can be user defined)
- What public website allows above decrypting? I would love to use EncryptByPassPhrase, and DecryptByPassPhrase. But I cannot find any webpage able to decypt it. An I'm not programmer, nor Website-developer. Just plain sql-developer.
Help Please...
Tomek
December 11, 2014 at 8:13 am
tomek tomek (12/11/2014)
I have a following situation.1. I need to encrypt set of strings in t-sql. These encrypted strings will be manually delivered to users.
2. Users have neither knowledge nor access to sql server. I'd like them to go to a website copy/paste the hash and get the original string.
- There are no security requirements. Just that the hash doesn't look like original string
- On the other hand it's important that access to the website and decrypting process is ultra-easy for the users.
- Do you know what t-sql function I can use(it can be user defined)
- What public website allows above decrypting? I would love to use EncryptByPassPhrase, and DecryptByPassPhrase. But I cannot find any webpage able to decypt it. An I'm not programmer, nor Website-developer. Just plain sql-developer.
Help Please...
Tomek
If the website has no security what is the point of the encryption in the first place? You are going to pass it across an unsecure channel in plain text.
You are going to need your own decryption page for this so you can leverage sql server to decrypt this for you.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 11, 2014 at 8:26 am
the point is, no one knows the real content (even I, as admin) - until decrypted on a website.
Unfortunately,
i don't have enough knowledge to build my own website conneceted to sql server.
T.
December 11, 2014 at 8:33 am
tomek tomek (12/11/2014)
the point is, no one knows the real content (even I, as admin) - until decrypted on a website.Unfortunately,
i don't have enough knowledge to build my own website conneceted to sql server.
T.
What I am saying is that you (or somebody else) will need to write the decryption logic, thus the protected data is really not secure anymore. It seems kind of funny to encrypt data and keep it super secret but let anybody who has the encrypted value decrypt it. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply