Title: Message
CREATE OR REPLACE TRIGGER sys.XXX_onlogon
AFTER LOGON
ON DATABASE
DECLARE
USUARIOW VARCHAR2(25)
:= '';
COMPUTADORAW VARCHAR2(25)
:= '';
BEGIN
SELECT OSUSER, MACHINE INTO USUARIOW, COMPUTADORAW
FROM V$SESSION
WHERE
AUDSID = USERENV('SESSIONID');
INSERT INTO SYSTEM.CONTROL_
Title: ROWID question?
Problem solved
You can get the sid from v$mystat, having
this we can then query v$session for the rest.
George
George
Leonard
Oracle Database
Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006