Share this page
KNTA_LOGON_ATTEMPTS
This table stores all of the attempts to log on to the server, both successful and failed. If there was a failure, the failure message name is stored as well.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
USER_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
LOGON_ATTEMPT_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
USER_ID |
NULLABLE |
NUMBER |
Identifier for the user who tried to connect |
|
USERNAME |
NOT NULL |
VARCHAR2(200) |
Username of the user who tried to connect |
|
CLIENT_ADDRESS |
NOT NULL |
VARCHAR2(100) |
IP address the client attempted to connect from |
|
SUCCESS_FLAG |
NOT NULL |
VARCHAR2(1) |
Whether or not the logon was completed successfully |
|
FAILURE_MESSAGE_NAME |
NULLABLE |
VARCHAR2(30) |
Reason for failure if the attempt failed |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KNTA_LOGON_ATTEMPTS_N1 |
NONUNIQUE |
1 |
USERNAME |
|
KNTA_LOGON_ATTEMPTS_U1 |
UNIQUE |
1 |
LOGON_ATTEMPT_ID |
|
KNTA_LOGON_ATTEMPTS_U2 |
UNIQUE |
1 |
USER_ID |
|
KNTA_LOGON_ATTEMPTS_U2 |
UNIQUE |
2 |
CREATION_DATE |
|
KNTA_LOGON_ATTEMPTS_U2 |
UNIQUE |
3 |
LOGON_ATTEMPT_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KNTA_LOGON_ATTEMPTS_S |
LOGON_ATTEMPT_ID |
