Re: methodology to keep only certain programs to connect to

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 10 Sep 2002 12:58:02 -0400
Message-Id: <22528.293350@fatcity.com>

This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages.

--=_BEE2F0B1.6E0F3AEF
Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable

Jared(and others)=20
thanks, a bunch you all had what i was looking for perfectly.

joe

>>> <Jared.Still_at_radisys.com> 09/10/02 12:55PM >>> Joe,

Try this:

select

   s.username,
   s.sid,
   s.serial#

from v$session s
where userenv('SESSIONID') =3D s.audsid;

Jared

"JOE TESTA" <JTESTA_at_longaberger.com>
Sent by: root_at_fatcity.com
09/10/2002 08:58 AM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>=

        cc:=20
        Subject:        methodology to keep only certain programs to =

connect to

I've been tasked to ensure only certain app programs access the database.

I'm thinking on-logon trigger, check the program field from v$session.=20 unfortunately v$session is for all sessions, i can't seem to find the = view=20
that tells me only MY info during login. I only want the sid, serial#,=20 username and program for my just now connection to the database.

Does this exist or am I going about this the wrong way?

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=20
in the community).

any ideas would be greatly appreciated.

joe

--=_BEE2F0B1.6E0F3AEF

Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-125=
2">
<META content=3D"MSHTML 5.50.4916.2300" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN-TOP: 2px; FONT: 10pt Times New Roman; MARGIN-LEFT: =

2px">


<DIV>Jared(and others) </DIV>

<DIV>thanks, a bunch you all had what i was looking for perfectly.</DIV>

<DIV>&nbsp;</DIV>

<DIV>joe</DIV>
<DIV> >>> <Jared.Still_at_radisys.com> 09/10/02 =
12:55PM=20
>>> Joe, Try this: select   =20 s.username,    s.sid,    s.serial# from = v$session=20
s where  userenv('SESSIONID') =3D=20 s.audsid; Jared "JOE TESTA"=20 <JTESTA_at_longaberger.com> Sent by: root_at_fatcity.com 09/10/2002 = 08:58=20
AM Please respond to=20
ORACLE-L        =20 To:     Multiple recipients of list ORACLE-L=20 <ORACLE-L_at_fatcity.com>         = cc:=20
        =20
Subject:        methodology to keep = only=20
certain programs to connect to I've been tasked to ensure = only=20
certain app programs access the database. I'm thinking on-logon = trigger,=20
check the program field from v$session. unfortunately v$session is for = all=20
sessions, i can't seem to find the view that tells me only MY info = during=20
login.  I only want the sid, serial#, username and program for my = just=20
now connection to the database. Does this exist or am I going about = this=20
the wrong way? We're thinking of checking those fields to make = sure=20
sql*plus, toad, etc can't connect as a particular user(even though = the=20
password is known out in the community). any ideas would be = Received on Tue Sep 10 2002 - 11:58:02 CDT