query about user and password.

[Former Member]

how we will get the usernames and passwords?

in which tables this two are found,give table names.

[Former Member]

Hello Bhaskar

Usernames are stored in the table USR*. Especially the password would be stored in the table USR02 after applying some encryptions algorithms.

Regards

Ranganath

[Former Member]

Hi,

SAP stores password hashes and the version of the password hash

alggorithm of the currrently used password and of 5 previously

used passwords in the database table USR02.

In addition, the password hash (but not the CODVN of the algorithm)

is stored in a newly created record in DB table USH02, whenever the

user changes his password, or whenever an admin changes the

valid-from or valid-to date of a user, locks or unlocks a user, etc.

(That means, DB table USH02 stores all password hashes of all

users since the SAP system has been installed, with user name,

date and time as key fields.)

Regards

Gaurav