title: Eclipse BIRT and Oracle: Need to set role before running report
body: <p>Is it possible to set a database role before running a report? I have a number of databases each containing a number of schemas with the same set of tables, where each schema has a number of roles to control read, write, data management and so on. None of these are default roles. </p>
  
  <p>In sqlplus or TOAD I can do SET ROLE , before running a select statement. I would like to do the same in BIRT.</p>
  
  <p>It may be possible to do this using the afterOpen event for the ODA Data Source, but I have not found any examples on how to get and use the native connection in JavaScript.</p>
  
  <p>I am not allowed to add or change anything on the server end.</p>