Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 'Auditing' user connections
I am using that on some databases because the customer wants to know who
is logging in and for how long. So, I'm using logon and logoff
triggers to capture that information, then I have a cron job that
generates a report for her every Monday.
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Jared.Still_at_radisys.com
Sent: Monday, August 16, 2004 4:25 PM
To: oracle-l_at_freelists.org
Subject: Re: 'Auditing' user connections
> I have been asked to track user connections to a database (9.2) to=20
> see what logins are being used, where they are coming from, etc.=20
> Auditing first comes to mind, but our maintenance window for a db=20
> restart is not for a few weeks and the information is being=20
> requested ASAP. The first thing that comes to mind is a database=20
> logon trigger and a table to capture the relevant information.
>=20
Hi Dan,
I've used the same approach, for the same reason.
Don't know of an alternate method.
Jared
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Aug 16 2004 - 15:37:37 CDT
![]() |
![]() |