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
Received on Sun Sep 17 2006 - 07:00:03 CDT
