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

You can query the v$session view. It contains information about all current sessions.
For example the query:

SELECT
       sid,serial#,username,osuser,module,machine FROM
       v$session
WHERE
       module = 'SQL*Plus';

returns this kind of result

      SID SERIAL# USERNAME OSUSER MODULE MACHINE

--------- ---------   ----------------- --------------- ------------   -----

       11 78 SYSTEM rferrari SQL*Plus IDPTCN You can use it to kill the session (alter system kill session '11,78') or to automatically generate and run a script the perfoorms it.

Hope to be useful
Riccardo

Agi <agichen_at_my-deja.com> wrote in message 7ue6hd$ros$1_at_nnrp1.deja.com...
> 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.
Received on Mon Oct 18 1999 - 19:26:34 CEST