Need to spoof sys_context OS_USER in SSRS to provide end-user details to Oracle RLS - Can ODP.NET he

 Hi All,

select sys_context('USERENV',OS_USER) from dual

select sys_context('USERENV','EXTERNAL_NAME') from dual

When called from SqlServer Reporting Services, these queries either give blank or a name like "SQLServiceUser" or

"NetworkServices".  I would like to set one of them in SSRS to be the User!UserID global, which will be a per-enduser string like "gspe2009" or "tcar1411".

That way I can derive additional security attributes in Oracle RLS on a per-enduser basis.

Is there a session variable or a connection string parameter that is accessible to programmers to alter the values sent to Oracle by an connection?