get User PAssword?

julkifli33

hi all
can we get user password?
like USERID.... is there a code to get user password?

mohana_cse06

If you are talking of database authentication passwords then you can get them in table 2000000002

navuser1

julkifli33 wrote:

hi all
can we get user password?
like USERID.... is there a code to get user password?

I think you could not get password

julkifli33

mohana_cse06 wrote:

If you are talking of database authentication passwords then you can get them in table 2000000002

i think this one is sql password
i need to get somethink like if you put 'USERID', it will show your user id
either windows authentication or sql database authentication

kriki

If you are on a native DB, it is in table 2000000002, but it is encrypted. And you can't decrypt it. The only way is to give a PW, encrypt it en confront it with the PW in the table.


If you are on SQL DB AND have DB logins, the encryption is in table master..SYSLOGINS but again the are encrypted, so you can't get them.
Advantage: you can use the SQL DB also from other systems
Disadvantage: If I remember well, the passwords fly UNENCRYPTED over the network, so you can intercept them.


If you are on SQL DB AND have Windows logins, the passwords are not even in SQL DB but in the Windows domain.
Disadvantage: Windows systems only
Advantage: the passwords fly over the network in an encrypted form, so it is impossible to intercept them.