HCI_USER
SAP CC Users (Technical Settings)
Description
The HCI_USER table contains information about the authorized users of the connected
SAP CC system.
They can be humans or systems (individual users or service users).
The USER_RIGHT table includes the authorization roles assigned to an SAP CC user.
Technical Data
Summary
The HCI_USER table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The unique ID of an SAP CC user. It is generated by the SAP CC system. |
| Type |
DECIMAL(28), NOT NULL |
| Primary Key |
PK_HCI_USER |
LOGIN_ID
| Definition |
The SAP user logon |
| Type |
NVARCHAR(64), NOT NULL |
| Available Index |
IX_LOGIN |
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 hashed password of the SAP CC user. The hashing algorithm used is SHA-256. |
| Type |
NVARCHAR(1000), 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 |
CATALOG_NAME
| Definition |
The name of the pricing catalog the SAP CC user is associated to |
| Format |
- If this field is not set, the SAP CC user has access to objects from every pricing
catalog defined in the SAP CC system.
- If this field is set with the name of a catalog, the user only has access to the objects
contained in this catalog.
|
| Type |
NVARCHAR(64), NULL |
LAST_ACTIVITY_DATE
| Definition |
The date of the last activity of the SAP CC user |
| Type |
DATETIME, NULL |
PASSWORD_CHANGE_DATE
| Definition |
The last modification date of the password |
| Description |
The last modification date of the password. This field is used only if the advanced
password management is enabled.
|
| Format |
The NULL value can be used to force the expiration of the password. At the creation of a new
SAP CC user, the field is filled with the NULL value, so that the user must change
his password at the first logon.
|
| Type |
DATETIME, NULL |
FAILED_LOGIN_COUNT
| Definition |
The number of times the user entered a wrong password when trying to log in |
| Description |
The number of times the user entered a wrong password when trying to log in. If the
advanced password management is enabled and if the value of FAILED_LOGIN_COUNT is
greater than the maximum number of allowed errors (defined by the parameter PASSWORD_MANAGEMENT_FAIL_LIMIT),
the user account is locked. The user cannot do anything until it is unlocked by an
administrator.
|
| Format |
The initial value of this field is 0, and it is reset every time the password of the SAP user is modified.
|
| Type |
DECIMAL(3), NOT NULL |
LOCKED
| Definition |
The field LOCKED specifies if the user is locked or not |
| Description |
The field LOCKED specifies if the user is locked or not. This field is used only if
the advanced password management function is enabled.
|
| Type |
DECIMAL(1), NOT NULL |
IS_HUMAN
| Definition |
The field IS_HUMAN specifies if the SAP CC user is a human user, or a non-human (service)
user
|
| Description |
The field IS_HUMAN specifies if the SAP CC user is a human user, or a non-human (service)
user. Service users have fewer constraints relative to their passwords:
they cannot be locked due to authentication failures, and their password never expire.
|
| Type |
DECIMAL(1), NOT NULL |
CHANGE_PASSWORD
| Definition |
The field CHANGE_PASSWORD specifies if the SAP user must change its password at the
next logon
|
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
Primary Key Details
PK_HCI_USER
Index Details
The following database indexes are available in the
HCI_USER database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_LOGIN
| Indexed Column(s) |
LOGIN_ID |
| Unique |
Yes |
| Partitioned |
No |
| Clustered |
No |
| Filegroup |
CATALOG_INDX |
