On Sun, 17 Sep 2006 10:03:31 GMT, "Simo Silmu" <kalle@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