Ask the Expert

Capturing LOGON events in 7.3

I have a procedure that I use in our Oracle 8 and 9 databases that is invoked after a LOGON EVENT. The script stores the name of the user, month/year of access, and increments the number of accesses in that month/year. The script is here.

We have found it quite handy for determining who is logging on to which databases and how often. What I would really like to do it to is to have the same ability to track access in our Oracle 7.3 databases. But given that there is no LOGON EVENT, is there another way to create a trigger that does the same thing... fires when a logon is detected?

I have looked at auditing (high overhead), and I have looked at manually parsing the listener logs (time consuming), but this script seems to best meets our needs.


    Requires Free Membership to View

I don't know of any way to easily capture a logon event in 7.3. You might be able to set up a job to run every few seconds (or less) to check v$session, compare it to an earlier copy of v$session and then compare the two. For any user that was not there previously, you could write a login record to your tracking table and for any user who was there previously but is not there now, you could write a logout record. I think this would be a weak option at the very best and would think that if all you want to audit is logins and logouts, using auditing overhead shouldn't be out of control and easily maintainable. I'd probably stick with that and not try to re-invent the wheel with a solution that may be not so good or time consuming (as you mentioned in your idea to parse the listener logs).

For More Information


This was first published in January 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: