[Home] [Help] [Dependency Information]
Object Name: | FND_UNSUCCESSFUL_LOGINS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_UNSUCCESSFUL_LOGINS |
Subobject Name: | |
Status: | VALID |
FND_UNSUCCESSFUL_LOGINS stores Sign-On Audit information about
unsuccessful login attempts. Each row includes values that
identify the application user, the operating system login name of
the user and the operating system name of the user's terminal, as
well as the time the user tried to sign on to an application. You
need one row for each unsuccessful login attempt. Oracle
Application Object Library uses this information to provide
Sign-On Audit information.
.
.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_UNSUCCESSFUL_LOGINS_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
USER_ID
ATTEMPT_TIME |
FND_UNSUCCESSFUL_LOGINS_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LOGIN_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_ID | NUMBER | (15) | Yes | The application user identifier |
ATTEMPT_TIME | DATE | Yes | The number of times the user tried to sign on to the application | |
LOGIN_NAME | VARCHAR2 | (30) | Yes | The operating system login name of the user |
TERMINAL_ID | VARCHAR2 | (30) | Yes | The operating system name of the user's terminal |
Cut, paste (and edit) the following text to query this object:
SELECT USER_ID
, ATTEMPT_TIME
, LOGIN_NAME
, TERMINAL_ID
FROM APPLSYS.FND_UNSUCCESSFUL_LOGINS;
APPLSYS.FND_UNSUCCESSFUL_LOGINS does not reference any database object
APPLSYS.FND_UNSUCCESSFUL_LOGINS is referenced by following:
|
|
|