sessionid always returns 0 in AFTER LOGON

From: Rahul <rahul_at_ratelindo.co.id>
Date: Fri, 8 Sep 2000 13:21:07 +0700
Message-Id: <10613.116490@fatcity.com>

List,
i was trying to implement AFTER LOGON trigger on a schema when i found out that i cannot use - audsid = userend('sessionid') !!! the trigger always returns sessionid as 0 (zero) which is for background processes !!

CREATE OR REPLACE TRIGGER logon_audit
AFTER LOGON ON scott.schema
declare

	CURSOR c1 IS
		SELECT osuser, machine,audsid
		FROM	sys.v_$session 
		where	audsid = userenv('sessionid');

begin         

end;
/

is there a way i can identify the session which just connected ???

TIA Rahul

PS: checked metalink.. the examples uses userenv('sessoinid') also... which, i think, is wrong.. Received on Fri Sep 08 2000 - 01:21:07 CDT