RE: Identifying Business Objects Users
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: "John Kanagaraj" <john.kanagaraj@xxxxxxx>, <sharmakdeep_oracle@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Aug 2005 16:32:16 -0600
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.
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: John Kanagaraj [mailto:john.kanagaraj@xxxxxxx]
Sent: Wednesday, August 10, 2005 4:25 PM
To: Reidy, Ron; sharmakdeep_oracle@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Reidy, Ron
Sent: Wednesday, August 10, 2005 12:04 PM
To: sharmakdeep_oracle@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Identifying Business Objects Users
v$session.module
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Deepak Sharma
Sent: Wednesday, August 10, 2005 11:20 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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.
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
