BO/Oracle Connections

[malves]

Hi,

We have a DW that uses BO as its reporting tool, at the database level (ORACLE) all queries are ran by the same user and from the same machine (the one where the BO server is installed) making impossible to check who is running what. when something is wrong with the queries the the users launch I would like to call them and asking what they are doing, however becouse all connections appear in Oracle with the same user/machine I don't know who is running what.

Is there any way to change the way BO connects to the database ?
Another solution would be call a procedure to set some oracle application info (dbms_application_info.set_module) however I don't know if I can change BO connection to call a procedure each time a user connects. Is it possible ?

Thanks in advance,
Miguel

 

[TheVMan]

Miguel,
The problem you are experiencing is the very reason that we tend to shy away from group ids connecting to the DB. The obvious answer is to have your connection changed to use @variable('BOUSER') and @variable('BOPASS'), so that the currently logged in user will have his credentials passed to the DB. Clearly this means you have to set each user up with select access to your DB.

Hope that helps.
V