Trigger de Logon

[RoninParticipante]

Bom dia,

  Pessoal, o que tem de errado nessa trigger de logon ?

CREATE OR REPLACE TRIGGER TRG_RESTRICAO_ACESSO
AFTER LOGON ON DATABASE
DECLARE
USERNAME VARCHAR2(50);
SID NUMBER;
SERIAL NUMBER;
MODULE VARCHAR2(100);
BEGIN
SELECT SID,SERIAL#,MODULE,USERNAME INTO SID,SERIAL,MODULE,USERNAME FROM V$SESSION WHERE AUDSID=SYS_CONTEXT(‘userenv’,’sessionid’);
IF USERNAME = ‘SIGA’ AND MODULE NOT IN (‘SGCRYS32.exe’,’w3wp.exe’) THEN
EXECUTE IMMEDIATE ‘ALTER SYSTEM KILL SESSION ”’||sid||’,’||serial||””;
END IF;
END;