ACCLOGSUB

This table contains detailed information of the request causing access violation. The entries are linked to the ACCLOGMAIN table.

Column Descriptions:

NameTypeDescription
ACCLOGSUB_IDBIGINT NOT NULLThe primary key.
ACCLOGMAIN_IDBIGINT NOT NULLForeign key to the ACCLOGMAIN table.
LOGTIMETIMESTAMPThe time the access violation occurred.
ACTIONVARCHAR (254)A description of what the request tried to do.
RESULTVARCHAR (254)The result of the access control check.
RESOURCESVARCHAR (254)The resources accessed by the request.
USERS_IDBIGINT NOT NULLThe ID of the user executing the request.
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>ACCLOGSUB_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_18ACCLOGMAIN_IDACCLOGMAINACCLOGMAIN_IDCascade