Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Access and password changes

RE: Access and password changes

From: Mercadante, Thomas F \(LABOR\) <>
Date: Thu, 8 Feb 2007 10:23:33 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08B0E@EXCNYSM0A1AJ.nysemail.nyenet>


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.

[] On Behalf Of
Sent: Thursday, February 08, 2007 10:16 AM To:
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 Oracle9.

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.

Received on Thu Feb 08 2007 - 09:23:33 CST

Original text of this message