RE: methodology to keep only certain programs to connect to

From: Nastase, Mr. C. (Catalin) <CNastase_at_primagaz.fr>
Date: Tue, 10 Sep 2002 17:57:56 +0200
Message-Id: <22528.293327@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C258E2.D43CC200
Content-Type: text/plain;

charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

Joe,
=20
you may try:=20
select sid, serial#, username, program from v$session where audsid =3D userenv( 'sessionid')
=20
Regards,
Catalin Nastase
=20

-----Message d'origine-----
De: JOE TESTA [mailto:JTESTA_at_longaberger.com] Date: mardi 10 septembre 2002 17:58
=C0: Multiple recipients of list ORACLE-L Objet: methodology to keep only certain programs to connect to

I've been tasked to ensure only certain app programs access the = database.
=20
I'm thinking on-logon trigger, check the program field from v$session. unfortunately v$session is for all sessions, i can't seem to find the = view
that tells me only MY info during login. I only want the sid, serial#, username and program for my just now connection to the database. =20
Does this exist or am I going about this the wrong way? =20
We're thinking of checking those fields to make sure sql*plus, toad, = etc
can't connect as a particular user(even though the password is known = out in
the community).
=20
any ideas would be greatly appreciated.
=20
joe
=20

------_=_NextPart_001_01C258E2.D43CC200
Content-Type: text/html;

charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DISO-8859-1">

<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN-TOP: 2px; FONT: 10pt Times New Roman; =
MARGIN-LEFT: 2px">
<DIV><SPAN class=3D483335715-10092002><FONT =
face=3DArial>Joe,</FONT></SPAN></DIV>
<DIV><SPAN class=3D483335715-10092002><FONT =
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D483335715-10092002><FONT face=3DArial>you may try:=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D483335715-10092002><FONT face=3DArial>select sid, =
serial#,=20
username, program from v$session where audsid =3D userenv(=20 'sessionid')</FONT></SPAN></DIV>
<DIV><SPAN class=3D483335715-10092002><FONT =
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D483335715-10092002><FONT=20
face=3DArial>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=3D483335715-10092002><FONT face=3DArial>Catalin=20
Nastase</FONT></SPAN></DIV>
<DIV><SPAN class=3D483335715-10092002><FONT =
face=3DArial></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px = solid; MARGIN-RIGHT: 0px">
  <DIV>-----Message d'origine-----<BR><B>De:</B> JOE TESTA=20   [mailto:JTESTA_at_longaberger.com]<BR><B>Date:</B> mardi 10 septembre = 2002=20
  17:58<BR><B>=C0:</B> Multiple recipients of list = ORACLE-L<BR><B>Objet:</B>=20
  methodology to keep only certain programs to connect to<BR><BR></DIV>   <DIV>I've been tasked to ensure only certain app programs access the=20   database.</DIV>
  <DIV> </DIV>
  <DIV>I'm thinking on-logon trigger, check the program field from=20   v$session.  unfortunately v$session is for all sessions, i can't = seem to=20
  find the view that tells me only MY info during login.  I only = want the=20
  sid, serial#, username and program for my just now connection to the=20   database.</DIV>

  <DIV>&nbsp;</DIV>
  <DIV>Does this exist or am I going about this the wrong way?</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>We're thinking of checking those fields to make sure sql*plus, =

toad, etc=20
can't connect as a particular user(even though the password is known = out in=20
the community).</DIV>

  <DIV>&nbsp;</DIV>
  <DIV>any ideas would be greatly appreciated.</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>joe</DIV>

Received on Tue Sep 10 2002 - 10:57:56 CDT