See user's password

[blade99]

how can i see all users with their passwords in db?

[MentaL]

[PwrDex]

No way, because the database storing as hash..

[lifestream]

When you register, the sql uses pwdencrypt() and stores only hash.

So when yhe code runs and user logs in - the db is compared for a hash version of the database.
The real password isnt stored.

You can use SQL compare function - but that wont get you user password.
http://technet.microsoft.com/en-us/l.../dd822792.aspx

If this is so you could change forgotten passwords, then create a php etc function for it (that compares and then inserts new password).

However mailing user "forgotten" password... well..not going to work - it doesnt exist in database.

This way, even if DB gets hacked - they dont get user passwords, only hashes.

You can edit the register procedure and add non hashed password and user id t oa new table for later use...