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_at_ozemail.com.au>
Date: Sat, 7 Apr 2001 14:41:57 +1000
Message-ID: <MVwz6.665$pO2.25720_at_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 Sat Apr 07 2001 - 06:41:57 CEST