logon monitoriing
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
0