RE: Access and password changes

  • From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <Joel.Patterson@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 8 Feb 2007 10:23:33 -0500



Create an ON LOGON database trigger and capture all logons into a new
database table.  You can capture all of the info in the v$session table,
so you can see everyone and everyplace a connection is coming from.  Run
this for a couple of weeks to see all the connections.


I do this in all my databases.



This transmission may contain confidential, proprietary, or privileged 
information which is intended solely for use by the individual or entity to 
whom it is addressed.  If you are not the intended recipient, you are hereby 
notified that any disclosure, dissemination, copying or distribution of this 
transmission or its attachments is strictly prohibited.  In addition, 
unauthorized access to this transmission may violate federal or State law, 
including the Electronic Communications Privacy Act of 1985.  If you have 
received this transmission in error, please notify the sender immediately by 
return e-mail and delete the transmission and its attachments.


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Sent: Thursday, February 08, 2007 10:16 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Access and password changes


Changing the password of the 'schema owner' - the owner of the data.


I have a manager who has asked if there is a way to track what
'application' is logging in before changing the password so that the
change can be smoother.   (either change the password in the app or
create a new account for the app).


The second part is can you track what application is attempting to log
in to a schema where the password has already been changed.   



The version of Oracle are 9, and 10.


A case where the password has already been changed happens to be

Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.

Other related posts: