473,320 Members | 2,122 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DB2 UDB V9.5 Windows ENCRYPT

It seems that I must pass a "SET ENCRYPTION PASSWORD =" to each stored
procedure that puts an encrypted value into a column. Also seems that
I don't have to specify that password when using DECRYPT_CHAR().

Does that mean that a different password can be used for each entry
into that column and the dbm stores it someplace?

This is important because it gives my app a chance to generate random
passwords and not have to remember them.

SS
Nov 16 '07 #1
1 2438
28******@gmail.com wrote:
It seems that I must pass a "SET ENCRYPTION PASSWORD =" to each stored
procedure that puts an encrypted value into a column. Also seems that
I don't have to specify that password when using DECRYPT_CHAR().

Does that mean that a different password can be used for each entry
into that column and the dbm stores it someplace?

This is important because it gives my app a chance to generate random
passwords and not have to remember them.
ENCRYPT/DECRYPT is meant for the user and not the system. So yes, each
row and each column can have a different password and it is the users
responsibility to know it. DB2 does NOT store the password. It does
store the "hint" (if provided).

Of course no-one prevents the system from using the feature itself for
its own purposes.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Nov 16 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sylvian Stone | last post by:
Hi, I need to use encryption functions with php, such as mcrypt_generic(), mcrypt_decrypt(), etc I have placed libmcrypt.dll in my windows/system32 directory. I can now encrypt, but not...
1
by: wqhdebian | last post by:
As far as I know,when encrypt or decrypt ,a key must first be got,and the key is first generate by a tool or from SecurityRandom,that means I can not generate the same key with the same input.Does...
7
by: dlinetsky | last post by:
I have a C# web app that uses mixed mode authentication (windows integrated auth. together with formsAuthentication). I would like to have a form that allows users to change their windows...
8
by: Pete Wittig | last post by:
Hello, I am wondering if it is possible to create a networked application with C# that is seen as a windows user. For example, if Bob logged onto windows and then started the application, any...
1
by: Tommy | last post by:
I want to encrypt the values of my cookies. I found out that I could create a FormsAuthenticationTicket, and use the FormsAuthentication.Encrypt method to encrypt the cookie. However, I do not...
4
by: Alan Samet | last post by:
Is there a way to easily and securely use the Windows Encrypted File System (EFS) with IIS and ASP.NET? Alternatively, I would prefer to find some sort of totally encrypted low-level device driver...
7
by: Jarod_24 | last post by:
I just downloaded a activex control that was written in C# and tried to view it on my PDA's Internet Explorer. At my regular PC it displayed just fine, but nothing showed up on the pda. Do...
10
by: Smurff | last post by:
Hi, This code works fine on win and linux but not on hpux. All is compiled with gcc. Can anyone help please? /*****************************************************************************/ /*...
1
by: huberth | last post by:
Hi, How to use System.IO.File.Encrypt with the framework 2.0 in Windows Vista? I can't encrypt a file. Thanks!
18
by: Rotsey | last post by:
Hi, I have a windows service that does some distributed transcation across 2 servers. One DB is SQL 2005 express and the other is SQL 2005. My question is I have created a domain user account...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.