Re: Challenge Question for DBA's

Create a logon trigger, which checks from v$session, what is the program name. If it's not sqlplus (or plus80, plus..) then kills it's own session?

I've never tried to kill my own session though..

Tanel Poder
a DBA

"M. Moiz" <moiznet2002_at_yahoo.com> wrote in message news:53b2483d.0107131220.712723e_at_posting.google.com...
> -------------------------------
> > A LAN of 5 pc's
> > 1 Server 4 Clients
> > OS = Win 2K Pro
> > Oracle Enterprise 8i DB Running on the Server
>
> Requirement:
> Connect the 4 clients to the Oracle Server, 'remember its a local LAN'.
> Such that the clients only make use of the SQL*Plus utility.
>
> Scenario_1: Using NET8 how do you make this possible.
>
> Scenario_2: Not using NET 8 how do you make this possible.
>
> HINT:
> You do not use any Network Server here, its a LAN.
>
> -------------------------------
Received on Mon Jul 16 2001 - 17:18:41 CEST