Getting current UserID

[Blackhawks4Life]

I have a trigger that I was using the following script to get the current UserID. We recently upgraded from Oracle 10g to 11g and now this query is returning NULL for both values. What I have found is that the SQL_ID in the V_$SESSION table is not being populated.

I am using Toad For Oracle on an Oracle 11g server.

SELECT SESS.OSUSER
    ,SESS.MACHINE
INTO v_USERID
    ,v_USERNAME
FROM SYS.V_$SQLAREA SEQL
JOIN SYS.V_$SESSION SESS ON SEQL.SQL_ID = SESS.SQL_ID
WHERE SEQL.SQL_TEXT LIKE 'DELETE%'
AND SEQL.SQL_TEXT LIKE '%ACCTLOG%';

Is there another option to get the UserID or another way to link to the V_$SESSION table?

We are using a Trigger because all of the query operations are passed in through a third party user software. There is only one login for the application so I needed to get to the individual PC information for the user.

Thanks!

 

[fredericofonseca]

look at

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions165.htm

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886