Re: [SQL] How to store a password encripted in a userdefinedtable

2007-03-01 Thread Bart Degryse
It doesn't do that for me. I've tried it on three different databases (of two different versions) as three different users and the result is always the same (as it should be): select USER, md5('password') current_usermd5 bigdbuser 5f4dcc3b5aa765d61d8327deb882cf99 current_user

Re: [SQL] How to store a password encripted in a userdefinedtable

2007-03-01 Thread Ezequias Rodrigues da Rocha
I am just passing the database owner password (postgresql autentication) to the statement: Select md5('the password I have in my mind') and compare with the password pgAdmin3 shows me. They are completely different. Ezequias 2007/3/1, Bart Degryse [EMAIL PROTECTED]: It doesn't do that for

Re: [SQL] How to store a password encripted in a userdefinedtable

2007-03-01 Thread Shane Ambler
Ezequias Rodrigues da Rocha wrote: I am just passing the database owner password (postgresql autentication) to the statement: Select md5('the password I have in my mind') and compare with the password pgAdmin3 shows me. They are completely different. Try SELECT 'md5'||md5('the password I

Re: [SQL] How to store a password encripted in a userdefinedtable

2007-03-01 Thread Adrian Klaver
On Thursday 01 March 2007 8:53 am, Ezequias Rodrigues da Rocha wrote: I am just passing the database owner password (postgresql autentication) to the statement: Select md5('the password I have in my mind') and compare with the password pgAdmin3 shows me. They are completely different.

Re: [SQL] How to store a password encripted in a userdefinedtable

2007-03-01 Thread Ezequias Rodrigues da Rocha
Perfect ! That's it. Another information I doesn't have. Great to be part of this list. Thank you Adrian 2007/3/1, Adrian Klaver [EMAIL PROTECTED]: On Thursday 01 March 2007 8:53 am, Ezequias Rodrigues da Rocha wrote: I am just passing the database owner password (postgresql autentication)