Is it possible through JBoss EDS to change the OS user for each new connection when using Oracle OS authentication?

Solution Unverified - Updated -

Issue

  • We need to create a connection to Oracle using OS authentication (username was passed to the security context) with a different user for each connection
  • Oracle pool connections needs to be reset each connection with OracleConnection.CONNECTION_PROPERTY_THIN_VSESSION_OSUSER
  • Is it possible to apply the OracleConnection.CONNECTION_PROPERTY_THIN_VSESSION_OSUSER to an active connection in Teiid Translator and how?
  • the OS user will be passed to service request (REST/Teiid JDBC) at the runtime to be used for the Oracle connection
  • we need to dynamically assign a user to Oracle connection at runtime.

Environment

  • Red Hat JBoss Enterprise Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.