HCI_USER

Table: HCI_USER

Table Name

HCI_USER

Table Description

The HCI_USER table contains information about the authorized users of SAP Convergent Charging APIs.

Tablespace

CATALOG_DATA

Database

Core Database

Columns

OID
LOGIN_ID
PASSWORD
CATALOG_NAME
LAST_ACTIVITY_DATE
PASSWORD_CHANGE_DATE
FAILED_LOGIN_COUNT
LOCKED
IS_HUMAN
CHANGE_PASSWORD

Columns of the Table

The HCI_USER database table is defined by the following columns.

Column: OID

Value Type	BIGINT, NOT NULL
Key(s)	Primary Key: PK_HCI_USER
Column Description	The user unique id, it is generated by the system.

Column: LOGIN_ID

Value Type	VARCHAR(64), NOT NULL
Index(es)	IX_LOGIN
Column Description	The user login.

Column: PASSWORD

Value Type	VARCHAR(1000)
Column Description	The encrypted password of the SAP Convergent Charging user.

Column: CATALOG_NAME

Value Type	VARCHAR(64)
Column Description	The name of the catalog the user is associated to. If this field is not set, the user has access to objects from every catalog defined in the system. If this field is set with the name of a catalog, the user only has access to the objects contained in this catalog.

Value Type

VARCHAR(64)

Column Description

The name of the catalog the user is associated to.

If this field is not set, the user has access to objects from every catalog defined in the system.
If this field is set with the name of a catalog, the user only has access to the objects contained in this catalog.

Column: LAST_ACTIVITY_DATE

Value Type	DATE
Column Description	The date of the last activity of the user.

Column: PASSWORD_CHANGE_DATE

Value Type	DATE
Column Description	The last modification date of the password. The NULL value can be used to force the expiration of the password. At the creation of a new user, the field is filled with the NULL value, so that the user must change his password at the first login. This field is used only if the advanced password management is enabled.

Value Type

DATE

Column Description

The last modification date of the password.

The NULL value can be used to force the expiration of the password. At the creation of a new user, the field is filled with the NULL value, so that the user must change his password at the first login.

This field is used only if the advanced password management is enabled.

Column: FAILED_LOGIN_COUNT

Value Type	DECIMAL(3), NOT NULL
Column 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. The initial value of this field is 0, and it is reset every time the password of the user is modified.

Value Type

DECIMAL(3), NOT NULL

Column 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.

The initial value of this field is 0, and it is reset every time the password of the user is modified.

Column: LOCKED

Value Type	DECIMAL(1), NOT NULL
Column Description	The field LOCKED specifies if the user is locked or not. This field is used only if the advanced password management is enabled.

Column: IS_HUMAN

Value Type	DECIMAL(1), NOT NULL
Column Description	The field IS_HUMAN specifies if the user is a human user, or a non-human (technical) user. Technical users have fewer constraints relative to their passwords: they cannot be locked due to authentication failures, and their password never expire.

Column: CHANGE_PASSWORD

Value Type	DECIMAL(1), NOT NULL
Default Value	0
Column Description	The field CHANGE_PASSWORD specifies if the user must change its password at the next logon.

Top of the list

SAP Convergent Charging 3.0

Document Version: SP04 and later