1. Administering Oracle Analytics Publisher in Oracle Transactional Business Intelligence
  2. Set Up Data Sources
  3. About Proxy Authentication

About Proxy Authentication

Publisher supports proxy authentication for connections to various data sources

Supported data sources include:

  • Oracle 10g database

  • Oracle 11g database

  • Oracle BI Server

For direct data source connections through JDBC and connections through a JNDI connection pool, Publisher enables you to select "Use Proxy Authentication". When you select Use Proxy Authentication, Publisher passes the user name of the individual user (as logged into Publisher) to the data source and thus preserves the client identity and privileges when the Publisher server connects to the data source.

Enabling this feature requires additional setup on the database. The database must have Virtual Private Database (VPD) enabled for row-level security.

For connections to the Oracle BI Server, Proxy Authentication is required. In this case, proxy authentication is handled by the Oracle BI Server, therefore the underlying database can be any database supported by the Oracle BI Server.