Re: Oracle Security Question

From: Christopher Latta <clatta_at_ozemail.com.au>
Date: Sat, 7 Apr 2001 14:41:57 +1000
Message-ID: <MVwz6.665$pO2.25720@ozemail.com.au>

You could do something giving access via stored procedures and basing your security on the information from v$session:

select OSUSER, TERMINAL

       from V$SESSION
       where AUDSID = userenv('sessionid')

Note that v$session truncates the OSUSER to 15 characters, so you might want to use the one from V$SESSION_CONNECT_INFO.

Christopher Latta

Richard L. Chen <richchen_at_ms6.hinet.net> wrote in message news:9ako8n$l9j_at_netnews.hinet.net...
> Hi,
> Is there any possible solution to prevent unauthorized client machines
> and/or unauthorized applications to access Oracle database even with valid
> userid and password ??
Received on Fri Apr 06 2001 - 23:41:57 CDT