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

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