Database Utilities (MOSC)

MOSC Banner

logon monitoriing

edited Jan 10, 2013 3:09PM in Database Utilities (MOSC) 8 commentsAnswered
I have an oracle STIG that requires that the number of sucessful and unsuccessful logons since the last successful logon be displayed when a user is accessing the database via sql plus.  does anyone have any idea how to do this?  I have logon triggers that populates an audit table, but how do show this interactively?  the logon trigger will only fire during a successful logon.  for successful logins I could query the table, but how to you show the results interactively?

and ideas would be greatly appreciated.

thanks in advance,

Rae

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