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: How to prevent users using toad and sqlplus from their client

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

From: Simo Silmu <kalle_at_nospam.com>
Date: Tue, 19 Sep 2006 11:01:59 GMT
Message-ID: <H6QPg.38606$_k2.694229@news2.nokia.com>


But on the other hand this works, I am totally confused:

create or replace trigger test after logon on database

2 begin

3 if user='TEST' then

4 raise_application_error(-20000, 'You are not allowed to login');

5 end if;

6 end;

7 / Received on Tue Sep 19 2006 - 06:01:59 CDT

Original text of this message

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