RE: sessionid always returns 0 in AFTER LOGON

From: Kirsh, Gary <gary.kirsh_at_gs.com>
Date: Fri, 8 Sep 2000 11:01:05 -0400
Message-Id: <10613.116514@fatcity.com>

Rahul,

Is this a standby database in read-only mode? If so, audsid will always be 0, as the db cannot generate an audsid without generating redo.

Gary

Gary Kirsh
Next Extent, Inc.

-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Friday, September 08, 2000 4:26 AM To: Multiple recipients of list ORACLE-L Subject: sessionid always returns 0 in AFTER LOGON

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..

-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Sep 08 2000 - 10:01:05 CDT