Re: SQLPlus version tracking

  • From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • To: "William.Blanchard@xxxxxxxxxxxxx" <William.Blanchard@xxxxxxxxxxxxx>
  • Date: Thu, 19 Jan 2012 13:27:39 -0600

Look at sys_context 'USERENV' and see if there are any contexts you can use to 
capture it.  I don't know if there is, but if there is, then you can create an 
on login sys trigger to log the info.

Again, I don't know if this info can be trapped with sys_context but it's worth 
a look.

Sent from my mobile device.  Please ignore any typos or misspellings.

On Jan 19, 2012, at 1:21 PM, "Blanchard, William G" 
<William.Blanchard@xxxxxxxxxxxxx> wrote:

> Does anyone know if there's a way to track the version of sqlplus that is 
> connecting to the database?  I looked at sys_context and system events but 
> haven't found anything.
> 
> WGB
> 
> 
> _____________
> The information contained in this message is proprietary and/or confidential. 
> If you are not the intended recipient, please: (i) delete the message and all 
> copies; (ii) do not disclose, distribute or use the message in any manner; 
> and (iii) notify the sender immediately. In addition, please be aware that 
> any message addressed to our domain is subject to archiving and review by 
> persons other than the intended recipient. Thank you.
> 
> --
> //www.freelists.org/webpage/oracle-l
> 
> 
> 

--
//www.freelists.org/webpage/oracle-l


Other related posts: