Re: Find unencrypted database connections

Checkout the view v$session_connect_info. It will show the connection encryption detail. I think you may have to use some filter predicates to limit the row that contains the encryption detail for each session.

+Senthil

Sent from my iPhone5

> On Nov 8, 2013, at 3:23 PM, LeRoy Kemnitz <lkemnitz_at_uwsa.edu> wrote:
>
> I am running Oracle 11.2 on Linux.
>
> Is there a way to monitor connections to the database and determine if the connection/session is encrypted? My goal here is to find the end users that are not encrypting, so I can contact them and provide info on how to do setup. I know I could change my settings to require an encrypted connection but I was hoping to be nice about it for a period of time. I have been going thru the v$ views and the listener logs with no luck yet.
>
> LeRoy
>
> ---------------
> LeRoy Kemnitz
> UW System Administration
> Database Administrator
> 780 Regent Street, #246
> Madison, WI 53714
> Phone: (608) 265 -5775
> Fax: (608) 265 - 2090
>

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