| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: methodology to keep only certain programs to connect to
This is a multi-part message in MIME format.
------=_NextPart_000_03B0_01C259A6.2959F640 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello Joe
I implemented today Tom's trigger in one of our test databases and it =
works fine.
I am using it to track which users / applications are connecting so we =
can notify them
in case of scheduled down time or problems.
You need to run dbmsrand.sql to add dbms_random package to the database.
Yechiel Adar
Mehish
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. =
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.
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 can't connect as a particular user(even though the password is known =
out in the community).
any ideas would be greatly appreciated.
joe
------=_NextPart_000_03B0_01C259A6.2959F640 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 content=3D"text/html; charset=3Diso-8859-1" =http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff=20
<DIV><FONT face=3DArial size=3D3>Hello Joe</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D4>I implemented today Tom's trigger in =one of our=20
<DIV> </DIV> <DIV><FONT size=3D4>Yechiel Adar<BR>Mehish</FONT></DIV> <BLOCKQUOTE=20
 |
 |