Re: Reject user connect to database via SQL*PLUS ??

From: Goin'n bold <jer_48_at_my-deja.com>
Date: Mon, 18 Oct 1999 10:26:45 GMT
Message-ID: <7ueskv$a6p$1@nnrp1.deja.com>

Hmmm,

Information regarding the connection to the database should contain the name of the loadmodule used (The .exe file in your case ). This information should be available in the system tables in the SYS schema.

If You could execute a small program ( or PL-SQL script ) that could be activated regulary by a trigger or a scheduler you could read the system tables, check for the connections being made och what program has made the connection.

Based on that information Your program should be able to kill those sessions that do not conform to the rules You set up.

Hope this gives You an approach on how to solve the problem.

/Jer

In article <7ue6hd$ros$1_at_nnrp1.deja.com>, Agi <agichen_at_my-deja.com> wrote:
> Hello,theres,
> Our users usually use discover to retrive data.
> Can I audit the user who uses sql*plus( or other tools like
> Access,Foxpro--via ODBC) to connect db ??
> Or even reject the requests except Discover users ????
>
> Any Idea ??
> Do appreciate for your help !!
> Rgds,
> Agi
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Gandhi: An eye for an eye only ends up making the whole world blind.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 18 1999 - 05:26:45 CDT