BI Publisher: BIP Permissions Not Migrated Correctly (Doc ID 2918984.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

The report files and data models were migrated with the catalog utility to another environment.
When checking the permissions in the target environment, the read permissions access on the objects to the default "BI Consumer" role was granted, when it originally had none.
Nothing should be added on top of the original permissions. This is causing security issues.


STEPS TO DUPLICATE
-----------------------
The issue can be reproduced at will with the following steps:
1. Migrate the report files and data models with the catalog utility
2. See that the migrated permissions are not exactly the original
3. access to the objects to the default "BI Consumer" role was granted

 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.