Alias: MAR#
(P2K_AM_ACCESS_RULES)Unique Keys: ACCESSOR_TYPE
ERD: ERD-AM90
description
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| ACCESSOR_TYPE | Varchar2(3) | X_ACCESSOR_TYPE | Y | |
| VALIDATION_METHOD | Varchar2(3) | X_VALIDATION_METHOD | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CREATE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| PASSWORD_LENGTH | Number(5) | NUMBER5 | ||
| PASSWORD_DIGIT | Varchar2(1) | TOGGLE | ||
| PASSWORD_PUNCTUATION | Varchar2(1) | TOGGLE | ||
| PASSWORD_DAYS | Number(5) | NUMBER5 | ||
| PASSWORD_MUST_CHANGE | Varchar2(1) | TOGGLE | ||
| EXPIRE_LOCK_AFTER_DAYS | Number(5) | NUMBER5 | ||
| NUMBER_PRIOR_PASSWORDS | Number(5) | NUMBER5 | ||
| LOGIN_ATTEMPTS | Number(5) | NUMBER5 | ||
| MAX_LOGIN_ATTEMPTS | Number(5) | NUMBER5 | ||
| IP_LOCKOUT_MINUTES | Number(5) | NUMBER5 | ||
| FORCE_PASSWORD_CHANGE | Varchar2(1) | TOGGLE | ||
| PASSWORD_BOTH_CASES | Varchar2(1) | TOGGLE | ||
| SITE_REFERENCE_ID | Number(10) | ID | Y |
User Fields: Not Allowed
Audit Logging: Not Allowed
