>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> Raj Mathur <raju@linux-delhi.org> writes:
>> mdu=# alter user raju with encrypted password 'raju'; ALTER
>> USER mdu=# select passwd from pg_shadow where usename='raju';
>> passwd
>> -------------------------------------
>> md5ef70c430d5ed1ed52bd2ae960bb8ebe4 (1 row)
>> mdu=# create user xxx with password
>> 'md5ef70c430d5ed1ed52bd2ae960bb8ebe4'; CREATE USER
Tom> That's not going to work, because the user name is included
Tom> into the password encryption algorithm, so two different
Tom> usernames with the same cleartext password are going to have
Tom> two different encrypted passwords. (This is a feature, not a
Tom> bug.)
Oooh, that's what I was missing then.
Tom> You can transfer the same usernames with the same passwords
Tom> from one system to another using the method shown above. You
Tom> cannot assign one user's password to another username this
Tom> way.
Great, it works now.
Thanks! Both PostgreSQL and you guys rock!
Regards,
-- Raju
--
Raj Mathur raju@kandalaya.org http://kandalaya.org/
GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F
It is the mind that moves