RE: Identifying Business Objects Users

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Wed, 10 Aug 2005 11:39:07 -0700
Message-ID: <960A9B249C99994AA3C7FCA016A0DA8902AA0BB8@ussccem08.corp.hds.com>

Deepak,

You can use the Query Governor (or something that has a similar name in BO) to record the user(s) who initiate queries, and use the V$SESSION.LOGON_TIME to tie this back. It is a pain, but this seems to be the only way...

Best,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)  

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com  

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Deepak Sharma
Sent: Wednesday, August 10, 2005 10:20 AM To: oracle-l_at_freelists.org
Subject: Identifying Business Objects Users

We are having trouble identifying users that connect to Oracle using Business Objects.

All we see as 'osuser' is 'busobj' (That's the Unix Id for business objects software), and 'username' is 'BUSOBJ_USER' (This is the oracle account that business objects uses).

We have looked into using application_info pkg, but the problem is that from BO we cannot implement it since when an SQL is fired from BO, it creates its own Oracle session.

Thanks,
Deepak                 

---

Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs  

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 10 2005 - 13:41:10 CDT