Message-Id: <22528.293350@fatcity.com> From: "JOE TESTA" Date: Tue, 10 Sep 2002 12:58:02 -0400 Subject: Re: methodology to keep only certain programs to connect to 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 >>> 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" Sent by: root@fatcity.com 09/10/2002 08:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L = 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

Jared(and others)

thanks, a bunch you all had what i was looking for perfectly.

joe

>>> <Jared.Still@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@longaberger.com>
Sent by: root@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@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 =