| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Identifying Business Objects Users
John,
I do not know BO (but I do get it after my morning runs :D). From the docs:
MODULE VARCHAR2(48) Contains the name of the currently executing module as set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure
If the program running is truly wiqt.exe, then there you go.
-----Original Message-----
From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com]
Sent: Wednesday, August 10, 2005 4:25 PM
To: Reidy, Ron; sharmakdeep_oracle_at_yahoo.com; oracle-l_at_freelists.org
Subject: RE: Identifying Business Objects Users
Ron,
v$sessionmodule for our BO reports shows 'wiqt.exe' consistently.... Is this enabled by a BO setting somewhere? It could also be related to the BO version - ours is 5.1.7 on the desktop and 2.7.3 for the web (as per our BO admin, so I may be wrong).
John
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Reidy, Ron
Sent: Wednesday, August 10, 2005 12:04 PM
To: sharmakdeep_oracle_at_yahoo.com; oracle-l_at_freelists.org
Subject: RE: Identifying Business Objects Users
v$session.module
-----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 11: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
--
http://www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
--
http://www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 10 2005 - 17:35:25 CDT
 |
 |