Re: advanced security confirmation

yeah, that's in the same catagory as tcpdump.  I was hoping for some v$dodad.

Jason's query is in the ballpark, but what about a session that is not your
current connection?  I'll be wanting to track who has not cut over before
I pull the plug on clear text.
 
Thanks, Jason:

SQL> select sys_context('USERENV','NETWORK_PROTOCOL') from dual;

SYS_CONTEXT('USERENV','NETWORK_PROTOCOL')
--------------------------------------------------------------------------------
tcps






On Wed, Jan 28, 2009 at 02:39:42PM -0800, K Gopalakrishnan wrote:
> Ray,
> 
> You may want to trace the sqlnet packets and see whether they are
> encrypted or not. Without ASO, you may see the SQLtext and data (in
> fixed with hex as well as ascii) format.
> 
> Set the sqlnet.ora parameter trace_level_client=support/16 to see the
> encrypted(!) data transfer .
> 
> -Gopal
> 
> 
> On Wed, Jan 28, 2009 at 1:58 PM, Ray Stell <stellr@xxxxxxxxxx> wrote:
> > besides tcpdump, is there a way to confirm a connection is being
> > encrypted via ssl?  anything in v$session?  Thanks.
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
> 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: