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

From: Simo Silmu <kalle_at_nospam.com>
Date: Tue, 19 Sep 2006 08:52:37 GMT
Message-ID: <pdOPg.38581$_k2.693964@news2.nokia.com>

Hmm,

still trigger doesn't fire, any ideas.

 1* select program, schemaname from gv$session where program='sqlplusw.exe' SQL> / PROGRAM

---

SCHEMANAME

---

sqlplusw.exe
TEST

---

CREATE OR REPLACE TRIGGER ban_sqlplus

   AFTER LOGON
   ON DATABASE
   declare
 v_program varchar2(48);
 v_schemaname varchar2(30);

    BEGIN
          SELECT program, schemaname into v_program, v_schemaname   FROM gv$session

          WHERE audsid=sys_context('USERENV','SESSIONID');

        IF v_schemaname='TEST' and v_program='sqlplusw.exe'
        THEN
            RAISE_APPLICATION_ERROR(-20001, 'You are not allowed to login');
        END IF;

    END;
/ Received on Tue Sep 19 2006 - 03:52:37 CDT