topic Re: query about user and password. in Application Development and Automation Discussions

query about user and password.

Former Member — Wed, 30 Jan 2008 05:26:22 GMT

how we will get the usernames and passwords?

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

Former Member — Wed, 30 Jan 2008 05:30:40 GMT

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 — Wed, 30 Jan 2008 05:32:22 GMT

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