Database Security Products (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center