In Fleet Management System users are assigned rights based on their department/group. The departments can be Finance, Operations and Administrators and rights that are assigned to them. Any access right is assigned based on group and users can be allotted within them, thus maintaining a filter of access. The groups that are part of Administrators have full rights. In case of invalid user name or password, warning gets displayed on the screen The user is locked out on the 7th time for 5 minutes after 6 attempts to login with incorrect credentials are made.
Fleet Management System has a screen dedicated to showing the log of users’ access to different modules and applications. The details of users are shown along with the activity they performed on the application. The date, workstation, OS User and user name are captured.
Logging In FMS Database Shore-Side
The log of user’s access to different modules in Fleet Management System application is stored in the ACTIVITY_LOG table in FCFMSADMIN schema in the database.
The ACTIVITY_LOG table logs in all activities of the user in the FMS System. These details can also be viewed from the application via ‘FMS Activity Log Viewer’
Any schema level DDL AUDIT triggers that trap any type of DDL activity performed on any schema. Each DDL activity performed is recorded in the FIDELIOBK.DDL_AUDIT table.
FIDELIOBK.DDL_AUDIT table traps activities like CREATE, ALTER, DROP, RENAME OR TRUNCATE ON SCHEMA.
Parent topic: Adding Users and Groups