Important Note on OBIEE 12c Visual Analyzer (Data Visualization) Security Settings

In OBIEE 12c, Oracle highly recommends to use Fusion Middleware Security Model.

One of the limitations in using initialization blocks is that Data Visualization doesn’t authenticate against init blocks.

Another important note is when migrating to FMW Security, users will not be able to login because the accounts were created in the Web Catalog with initialization blocks are not valid any more. When migrating, you will need to clean up the init block users form the Web Catalog and new valid accounts can then be created.

The below script will remove all the init block users from the Web Catalog cache.
Download Script

NOTE: PLEASE TAKE A CATALOG BACK UP BEFORE RUNNING THIS SCRIPT. THESE CHANGES CAN NOT BE REVERTED.

To run the script, copy it over to a server and execute it. Script will prompt the Administrator to enter the catalog path.

Author: Steve Yeung

Being in the EPM & BI field for more than 8 years, it's about time I contribute to newcomers! As a founder of MondayBI.com I wish to give you all the help I can. Feel free to give any suggestions or questions. Hope you will all enjoy this blog! William Wong Essbase Certified Specialist OBIEE Certified Specialist

2 thoughts on “Important Note on OBIEE 12c Visual Analyzer (Data Visualization) Security Settings”

  1. Hi William

    Can you please provide an overview of how the security works on OBIEE 12c visual analyzer ? Is there a way we can restrict a user just to obiee 12c Analytics and make visual analyzer inaccessible ?

    Like

    Reply

  2. Hi William,

    It is possible to setup the subjects areas that we want to be accessible by some users with Answers and Dashboards but not by Visual Analyzer nor Desktop Data Visualizator?

    Like

    Reply

Leave a comment