Re: How to prevent users using toad and sqlplus from their client

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 17 Sep 2006 06:32:54 -0700
Message-ID: <1158499972.933788@bubbleator.drizzle.com>

Sybrand Bakker wrote:
> On Sun, 17 Sep 2006 10:03:31 GMT, "Simo Silmu" <kalle_at_nospam.com>
> wrote:
>

>> Well,
>>
>> the subject tells it all but how would you prevent users using toad and 
>> sqlplus from their client (and perhaps getting nice denial message).
>>
>> Cheers
>> SS 
>>

> create an after logon trigger (assuming you are on a version >= 8.1),
> and determine the program using the sys_context function.
> Rest should be peanuts.
> However: if you have proper security set up, I don't think sql*plus
> access (which of course is readonly) should be a problem.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

One can also deal with SQL*Plus access using PRODUCT_USER_PROFILE.

A demo can be found in Morgan's Library at www.psoug.org.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Sun Sep 17 2006 - 08:32:54 CDT