Skip to Content
0
Apr 16, 2014 at 03:15 PM

BO4 - BEGIN_SQL + oracle to capture bouser and docname

59 Views

Hi,

We would like to know for each sql kicked off by web intelligence who the report user is and what the docname is.

Looking at the manual for idt can see reference to the BEGIN_SQL parameter but that is only teradata.

Anyone been able to use BEGIN_SQL to capture the docname + username for each sql which is running so that when sql running on database we can see what that relates to as all sessions on database just show as wireportserver.exe

Thanks