Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: Re: How do you encrypt a password column?

    Hi all,

    How do you encrypt a password column in SQL Server 2000 table?
    I would like to store something like *** in the column.

    Thanks much!

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    do you submit the same question every couple of weeks to drive me insane?
    If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd check here, or here for a couple of answers.

    -PatP

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I beleive it's an agent that wakes up once a week...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Try this:

    Code:
    create function EncryptPassword(@PasswordString varchar(20))
    returns char(10)
    as
    begin
    declare	@NewPassword varchar(20)
    set	@NewPassword = isnull(nullif(@PasswordString, @PasswordString), '**********')
    return	@NewPassword
    end
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Here is an even stronger algorithm. It uses a single-pass one-way encryption hash that is very secure. It is impossible to decrypt. As far as I know, this method has never been cracked:

    Code:
    drop function EncryptPassword
    go
    create function EncryptPassword(@PasswordString varchar(20))
    returns char(10)
    as
    begin
    declare	@ASCIICounter as integer
    set	@PasswordString = upper(@PasswordString)
    set	@ASCIICounter = ascii('A')
    
    while	@ASCIICounter <= ascii('Z')
    begin
    	set @PasswordString = replace(@PasswordString, char(@ASCIICounter), '*')
    	set @ASCIICounter = @ASCIICounter + 1
    end
    
    return	@PasswordString
    end
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    May 2002
    Posts
    395

    How do you encrypt a password column?

    Hi,

    To those who replied with help I appreciated always.
    To those who replied with criticisms don't reply at all. Who are you to judge other people. Either help or don't.
    Thanks!

  8. #8
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    Now look here. I posted some help when you asked this question 2 times ago. . In fact several fine solutions were suggested to your problem each time you posted this.

    I like helping people, but it gets a little fustrating answering the same question from the same person all of the time.

    If you do not understand the answers, say so. We will explain further but don't keep posting the same question. It's annoying.
    If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.

  9. #9
    Join Date
    May 2002
    Posts
    395

    Re: How do you encrypt a password column?

    You may have seen the post more than once someone may not.
    The possible solutions may not be the one One is seeking for.
    Its probably annoying or frustrating what you think is the problem. No one should be publicly humiliated.

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    YOU (alicejwz) need to quit posting the same d@mn question over and over again.

    Very knowledgeable, very intelligent, very patient, and very generous people have already given you the ONLY ANSWER YOU WILL GET.

    SEVERAL TIMES!

    And frankly, it is INSULTING that you just keep posting the same question hoping somebody new will give you a better answer.

    You think the people on this forum aren't smart enough to know the answer to such a simple question? Then go find some other forum to pester.

    Bleh!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by alicejwz
    Hi,

    To those who replied with help I appreciated always.
    To those who replied with criticisms don't reply at all. Who are you to judge other people. Either help or don't.
    Thanks!

    Ummm...do you know the difference?

    And lighten up Francis
    Attached Files Attached Files
    Last edited by Brett Kaiser; 02-11-05 at 15:52.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by blindman
    YOU (alicejwz) need to quit posting the same d@mn question over and over again.

    Very knowledgeable, very intelligent, very patient, and very generous people have already given you the ONLY ANSWER YOU WILL GET.

    SEVERAL TIMES!

    And frankly, it is INSULTING that you just keep posting the same question hoping somebody new will give you a better answer.

    You think the people on this forum aren't smart enough to know the answer to such a simple question? Then go find some other forum to pester.

    Bleh!

    Yo dude...who replied with help?

    EDIT: And where's Karolyn Been?

    I think that's her login
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by alicejwz
    You may have seen the post more than once someone may not.
    The possible solutions may not be the one One is seeking for.
    Its probably annoying or frustrating what you think is the problem. No one should be publicly humiliated.
    If you just want to bring the thread back to the top of the list, then "bump" it. Add a new posting at the end and simply comment that you are still looking for another answer, or even just the word "bump" by itself. That way the folks who've already responded will easily recognize both that they've already answered the question, and that you weren't satisfied with the answers you've gotten so far.

    The people who reply to questions are a scarce resource... Well over 90% of the people that visit will never post, and another 9% will only post questions. The remainder is all that we've got to provide answers, so anything that irritates them is a danger to the forum itself. I'm not trying to tell you to bow and scrape to the posters, but please consider that they volunteer to help with problems... If you want that resource available quickly, easily, and for free, you need to husband it carefully!

    Nobody is trying to humiliate you (yet), you'll know much more clearly when that happens! The repeated posting of the same question is like repeatedly asking the same question at a party... It is often ignored the first time it is repeated, sets people to whispering after that, and gets a rather stern lecture if it goes on too long. Right now you're well into the whispering stage with this question.

    -PatP

  14. #14
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404
    The possible solutions may not be the one One is seeking for.
    I posted something like that on the Pagan forum! (It seemed to be the right place for it.)


  15. #15
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Ryker
    I posted something like that on the Pagan forum! (It seemed to be the right place for it.)


    Do you mean the Oracle forum?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •