Analytics Access for Custom Views

After a Custom PLSQL archive is deployed successfully, all custom objects of type View that are included in the archive are identified and enabled for Analytics usage.

For each successfully deployed custom view, the deployment process performs the following actions:

• Grants SELECT access on the view to the OFSAA_ANALYTICS_PUB schema using GRANT WITH GRANT OPTION.
• Creates a synonym in the OFSAA_ANALYTICS_PUB schema for the corresponding view in the custom schema.
• Inserts the view details into the Custom PLSQL Master table with SRC_ID = ARC and SCHEMA_NAME = CUSTOM.
• Enables the SELECT grant for the view. Other grant types are marked as not applicable.
• If the view already exists in the Custom PLSQL Master table, the existing record is updated with the latest GRANT_DATE instead of creating a duplicate record.

After these actions are completed, the view can be queried from the SQL Query Browser in Oracle Analytics and used for creating reports and datasets.

Note:

The grant and synonym are created only for views that are deployed successfully. If archive deployment fails, or if a view fails during deployment, the Analytics grant and synonym creation are not completed for that view.