Does Oracle FDI allow users with the BI Consumer role, BI Author role, or an ERP application role to access the ADW database using SSO authentication?
Hi @User_7AIAG ,
Based on Oracle's documented FDI security model, the BI Consumer, BI Author, and ERP application roles are intended for accessing Fusion Data Intelligence content (dashboards, analyses, semantic model, etc.) through the FDI application. They do not grant direct access to the underlying Autonomous Data Warehouse (ADW) using SSO authentication.
Direct SSO access to the FDI ADW is a separate capability and requires explicit ADW database access to be provisioned. Having an FDI application role or an ERP application role alone is not sufficient to authenticate to the database.
Regards,
Arindam.
