To improve system security and audit capabilities, a function is requested that allows retroactive tracking of the activity of a selected user. Specifically, information about exports to Excel should be included.
Proposed solution
A new system table OrigamEvent (package Root) will be created, where records of selected user activities will be stored in the form of time, user, activity type (auxiliary table OrigamEventType), and more detailed information in text form.
In addition to the requested export to Excel, we also propose recording user logins and logouts, as well as screen openings.
Each type of event will have a separate switch in the form of a FEATURE.
An overview of events will be available on the Events screen in the Users and Security section (package Security).
Text information for individual events
-
user login – no detailed information
-
user logout – no detailed information
-
screen opening – screen name; if it is a detail screen with a dynamic name, it will contain the evaluated name, e.g., Contact David Novotný, Property Dobrý Domov
-
export to Excel – screen name, section name, and number of exported rows