Secure Data Access and Query Enforcement

Oracle Fusion Data Intelligence enforces both object security and data security at query runtime.

Users can access only:

• Authorized subject areas
• Authorized data rows

Physical Query Generation

The generated physical query automatically includes security filters. For example,

SELECT ...
FROM ...
WHERE OPERATING_UNIT IN
(
    'Vision Germany',
    'Vision Netherlands',
    'Vision Stores US'
)

The security framework ensures:

• Users see only authorized subject areas.
• Users see only authorized data.
• Security is enforced consistently across dashboards, analyses, and reports.
• Security enforcement occurs transparently within the semantic layer.