Re: Storing encrypted data in a database.

From: AlexS (salexru2000NO_at_SPAMsympaticoPLEASE.ca)
Date: 07/11/03


Date: Fri, 11 Jul 2003 12:00:27 -0700


Don't save passwords and names. Save and compare only hashes.
Btw, any byte array could be converted to string or char array.
HTH
Alex

"James Bender" <jbender@quicksolutions.com> wrote in message
news:03d501c347a6$86f014d0$a001280a@phx.gbl...
> Hi,
>
> I have an application I've written for a client which
> required users to login with a userid and a password,
> which I store in a users table (they cannot use windows
> auth, so yes, this is necessary).
>
> The problem I have is that I need to encrypt the password
> in the database. I have been trying to use some of the
> crypto classes for this, the problem is that key and
> encrytped values are turned into byte arrays. I have been
> having trouble storing these values in databases (MS SQL
> stores OK, I guess, but returns a values os System.Array
> that appears to have just one element. Sybase complains
> that I am missing an argument for my stored procedure).
>
> Is there a better was for me to do this? If not, can
> someone give me some advice on how to fix my database
> issues?
>
> Thanks,
> James



Relevant Pages

  • Re: KirbyBase
    ... creating objects from the database records was much easier. ... Hal, I don't know if you have had a chance to take a look at the beta yet, but I basically tried to implement a uniform way to specify one-to-one links, one-to-many links, and calculated fields in the ... I suppose it would in effect be embedding an array where all the ... My first couple of attempts at adding more complexity to KirbyBase did not honor this concept. ...
    (comp.lang.ruby)
  • Re: need some help with this solution...
    ... the whole file in a similar way as when fetching rows from the database (see ... You can choose to process the rows at the same time you fgetit or store ... uploaded file is a big one, then you will use more RAM if you store it in an ... Once I get the array ...
    (alt.php)
  • vb 2005 express > querry table in access and put contents into array
    ... I have a database that holds employee data. ... the phone login ID's for all of the agents in the table who are still ... i want to store each of those phone logins in an array, ... i just don't know how to make VB execute this statement and store the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: pause processing
    ... I'd like to give the user an opportunity to examine the print_rof that array before continuing. ... When the user submits the form, store the data in the database. ... If the data's not too big, you can store it in the $_SESSION array. ... if variable-pass1 is not set ...
    (comp.lang.php)
  • Re: Beginners Question on binary arrays and storage
    ... > I would like to store a bit array of 96 bits in a SQL record. ... opaque set of bits that does not mean anything to the database, ... a row in a table should have any array data. ...
    (microsoft.public.sqlserver.programming)

Quantcast