USER_PASSWORD
Description
The USER_PASSWORD table contains the history of passwords of the
SAP CC users.
Password history is stored only when advanced password management is enabled in the
SAP CC system.
Technical Data
| Schema Version |
4.5.13 |
|
| Partitioned |
No |
Summary
The USER_PASSWORD table is defined by the
following columns.
See the column details for more information.
Column Details
USER_OID
| Definition |
The unique identifier of the SAP CC user |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_PASSWORD |
SALT
| Definition |
The salt used to hash the password.
If it is null or empty, then no salt is used.
|
| Type |
NVARCHAR(64), NULL |
PASSWORD
| Definition |
The password of the SAP user |
| Type |
NVARCHAR(1000), NOT NULL |
ROUNDS
| Definition |
The number of rounds applied to the plain text password to obtain the hashed password.
The value 0 means that the former hashing algorithm
(one round of SHA-1) is in use for this user.
|
| Type |
DECIMAL(5), NOT NULL |
| Default |
0 |
CHANGE_DATE
| Definition |
The date when this password was changed |
| Type |
SECONDDATE, NOT NULL |
Index Details
The following database indexes are available in the
USER_PASSWORD database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_PASSWORD
| Indexed Column(s) |
USER_OID |
| Unique |
No |
| Partitioned |
No |
