USER_FAILED_AUTHENTICATION

Definition


The USER_FAILED_AUTHENTICATION table contains the list of failed authentication attempts for users since their last successful authentication

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


The USER_FAILED_AUTHENTICATION table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
USER_OID     IX_FAILED_AUTH  HCI_USER (OID)
 
 
RECORD_DATE          
SOURCE_ADDRESS          

Column Details


USER_OID

Definition The identifier of the SAP user
Type DECIMAL(28), NOT NULL
Available Index IX_FAILED_AUTH

RECORD_DATE

Definition The date and time when the failed authentication attempt occurred
Type DATE, NOT NULL

SOURCE_ADDRESS

Definition The IP address of the computer on which the failed attempt occurred
Type VARCHAR2(256 CHAR), NOT NULL

Index Details


The following database indexes are available in the USER_FAILED_AUTHENTICATION database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_FAILED_AUTH

Indexed Column(s) USER_OID
Unique No
Partitioned No
Tablespace CATALOG_INDX