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.

Advertisements

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”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s