Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reject user connect to database via SQL*PLUS ??

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

From: Izabella <Izabella.Urbanek_at_afp.gov.au>
Date: Tue, 19 Oct 1999 09:20:54 +1000
Message-ID: <7uga17$5v0$1@platinum.sge.net>


You may want to investigate the SYSTEM tables: USER_PROFILE or DBA_PROFILES. You can list the applications through which the users aren't allowed to connect, so you could specify that the users aren't allowed to connect through SQL*Plus for example.

HTH Agi 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 - 18:20:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US