RE: 'Auditing' user connections
- From: "Smith, Ron L." <rlsmith@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Aug 2004 08:09:21 -0500
We were asked to do the same thing on ALL production databases. That's
what Oracle auditing is for. If they want it turned on, they should be
willing to bounce the database. We audit for a couple of dozen things.
We have seen no performance hits after turning auditing on. We do NOT
audit data changes.
Ron
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Raj Jamadagni
Sent: Monday, August 16, 2004 5:23 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: 'Auditing' user connections
Dan,
I have been using db logon triggger and a table for more than 1.5 years
... no complaints. Make sure that the logon trigger doesn't get invalid
though ... in which case every connection will try to compile it, and
since most won't have privs to recompile it, it will hang for a timeout
and from then on it is downhill only. But if you take care of that,
things just run fine.
Raj
--- Daniel Fink <Daniel.Fink@xxxxxxx> wrote:
> I have been asked to track user connections to a database (9.2) to see
> what logins are being used, where they are coming from, etc. Auditing=20
> first comes to mind, but our maintenance window for a db restart is=20
> not for a few weeks and the information is being requested ASAP. The=20
> first thing that comes to mind is a database logon trigger and a table
> to capture the relevant information.
=3D=3D=3D=3D=3D
Best Regards
Raj
---------------------------------------------------------
select mandatory_disclaimer from company_requirements;
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
