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.
| Schema Version | 5.0.6 | |
| Partitioned | No | |
The USER_PASSWORD table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| USER_OID | IX_PASSWORD | HCI_USER (OID)
|
|
The unique identifier of the SAP CC user | ||
| SALT |
|
The salt used to hash the password. If it is null or empty, then no salt is used. | ||||
| PASSWORD |
|
The password of the SAP user | ||||
| ROUNDS |
|
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. | ||||
| CHANGE_DATE |
|
The date when this password was changed |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the SAP CC user |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_PASSWORD |
| Definition | The salt used to hash the password. If it is null or empty, then no salt is used. |
| Type | NVARCHAR(64), NULL |
| Definition | The password of the SAP user |
| Type | NVARCHAR(1000), NOT NULL |
| 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 |
| Definition | The date when this password was changed |
| Type | SECONDDATE, NOT NULL |
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:
| Indexed Column(s) | USER_OID |
| Unique | No |
| Partitioned | No |
