After Logon Trigger not working correctly
Hello Team,
As per Auditors, many users having Access to the AFG production databases, which store and process client confidential and sensitive data is not sufficiently restricted.
So Management have self-identified that controls to protect the integrity of the Leasesoft database could be improved. Access to the database is through a database tool – SQL Developer.
For this I have created 1 logon trigger on database, which collecting information from session coming from sql developer.
But I am getting lots of alerts from Nagios. (eg: other monitoring are not working due to this trigger)
++error from Nagios
CRITICAL - cannot connect to tstldnplora3_CQ. ORA-04088: error during execution of trigger SYS.LOG_T_LOGON