Discoverer - Public Connections for Oracle Applications with SSO
By M&S Consulting (Ashok) on Apr 11th, 2009
Filed Under Technical Tips // Tags: bi and reporting, identity management, oracle application server, oracle apps (ebs), oracle discoverer, oracle portal
Filed Under Technical Tips // Tags: bi and reporting, identity management, oracle application server, oracle apps (ebs), oracle discoverer, oracle portal
While using SSO, in order to create a public connection to Oracle Discoverer for Oracle Applications, I suggest creating a service account (user) in EBS and marking that user for LOCAL authentication (instead of SSO).
There may not be many reasons to create a public connection in this scenario, but I did come across one recently and it is not well-documented, so I thought I would share.
Of course, with Oracle BI Discoverer (non-Oracle-Applications), connections are made by database users and creating a public connection doesn’t require any EBS changes.
Related Information:
- Supplier Portal - Oracle EBS and Middleware
The Challenge
ABC, a publicly traded services and manufacturing organization, has leveraged Oracle E-Business Suite (EBS) to manage a variety... - Selected for Oracle iSupplier Portal Integrated Solution Bringing together many components of the Oracle Fusion Middleware Suite, as well as Oracle Applications (via E-Business Suite), M&S is...
- Applications with SQL Maintained Outside of Stored Procedures I have seen multiple custom solutions and packaged applications store their SQL outside of stored procedures. I am focusing this...
- Oracle APEX Tutorial 10 - Access Control - Part 1 - Video Training Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...
- Oracle APEX Tutorial 10 - Access Control - Part 2 - Video Training Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...
