PLCYACCT

This table stores the user account policies that consist of an account lockout policy and a password policy.

Column Descriptions:

NameTypeDescription
PLCYACCT_IDINTEGER NOT NULLThe ID for the Account Policy table (PLCYACCT).
PLCYACCLCK_IDBIGINT NOT NULLThe ID for the account lockout policy foreign key to the Account Lockout Policy table (PLCYACCLCK).
PLCYPASSWD_IDBIGINT NOT NULLThe ID for the password policy foreign key to the Password Policy table (PLCYPASSWD).
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PLCYACCT_IDPrimary Key
I0000695PLCYACCLCK_IDNon-Unique Index
I0000696PLCYPASSWD_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_599PLCYACCLCK_IDPLCYACCLCKPLCYACCLCK_IDCascade
F_600PLCYPASSWD_IDPLCYPASSWDPLCYPASSWD_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_598PLCYACCT_IDPLCYACCDSCPLCYACCT_IDCascade
F_894PLCYACCT_IDUSERREGPLCYACCT_IDCascade