[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_UNSUCCESSFUL_LOGINS

Object Details

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

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	5
PCT Used:

Indexes

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

Columns

Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_UNSUCCESSFUL_LOGINS does not reference any database object

APPLSYS.FND_UNSUCCESSFUL_LOGINS is referenced by following:

APPLSYS

FND_UNSUCCESSFUL_LOGINS#