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
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 |
DATETIME, 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 |
| Clustered |
No |
| Filegroup |
CATALOG_INDX |
