Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

Table: CAM_LOGIN_ATTEMPTS

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17377  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

A temporary table for tracking login failure for short period of time (tempLockoutSec) set in password policy table. A Oracle job is running background periodically and delete record older than tempLockoutSec.

Description

A temporary table for tracking login failure for short period of time (tempLockoutSec) set in password policy table. A Oracle job is running background periodically and delete record older than tempLockoutSec.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
NUMBER_OF_TRIALS
NUMBER 		Number of login failures
LAST_ATTEMPT_TIMESTAMP
TIMESTAMP(4) WITH LOCAL TIME Z 		Last timestamp of login failure. Precision 4. 1/1000th of a second.
APP_SEQ
NUMBER 		Primary key of CAM_MODULES table
USER_SEQ
NUMBER 		primary key sequence CAM_USERS table.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: Table: CAM_LOGIN_ATTEMPTS
Short Name: CAM_LOGIN_ATTEMPTS
Status: Completed
Abstract:

A temporary table for tracking login failure for short period of time (tempLockoutSec) set in password policy table. A Oracle job is running background periodically and delete record older than tempLockoutSec.
Notes:

Loaded by batch 3994, 01-03-2013 16:38

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CUST_AUTH
Description:

A temporary table for tracking login failure for short period of time (tempLockoutSec) set in password policy table. A Oracle job is running background periodically and delete record older than tempLockoutSec.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 NUMBER_OF_TRIALS NUMBER Number of login failures
100
 LAST_ATTEMPT_TIMESTAMP TIMESTAMP(4) WITH LOCAL TIME Z Last timestamp of login failure. Precision 4. 1/1000th of a second.
100
 APP_SEQ NUMBER Primary key of CAM_MODULES table
100
 USER_SEQ NUMBER primary key sequence CAM_USERS table.

Attribute Details

NUMBER_OF_TRIALS

CC ID: 84214
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Number of login failures
General Data Type: NUMBER

LAST_ATTEMPT_TIMESTAMP

CC ID: 84215
Seq. Order: 2
Data Storage Type: TIMESTAMP(4) WITH LOCAL TIME Z
Max Length: 11
Required: No
Primary Key: No
Scale: 4
Status: Active
Description:

Last timestamp of login failure. Precision 4. 1/1000th of a second.
General Data Type: TIMESTAMP(4) WITH LOCAL TIME Z

APP_SEQ

CC ID: 84217
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Primary key of CAM_MODULES table
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_APPS

USER_SEQ

CC ID: 84216
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

primary key sequence CAM_USERS table.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 17377
GUID: gov.noaa.nmfs.inport:17377
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-01-03 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18