Database Table: ACCLOGSUB

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

Column Name Column Type Column Description
ACCLOGMAIN_ID BIGINT
NOT NULL
Foreign key to the ACCLOGMAIN table.
ACCLOGSUB_ID BIGINT
NOT NULL
The primary key.
ACTION VARCHAR (254)
NULL
The description of what the request tried to do.
LOGTIME TIMESTAMP
NULL
The time the access violation occurred.
RESOURCES VARCHAR (254)
NULL
The resources accessed by the request.
RESULT VARCHAR (254)
NULL
The result of the access control check.
USERS_ID BIGINT
NOT NULL
The ID of the user executing the request.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034826690 ACCLOGSUB_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_17 USERS_ID USERS USERS_ID Cascade
F_18 ACCLOGMAIN_ID ACCLOGMAIN ACCLOGMAIN_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable