OBIEE 12c: Shared Folder Permissions Applied to "Subfolders & Items within Folder" Are Missing after Migration from 11g (Doc ID 2450057.1)

Last updated on SEPTEMBER 01, 2021

Applies to:

Symptoms

On Oracle Business Intelligence Enterprise Edition 12.2.1.3.0 version,

In OBIEE 12c, Shared Folder Permissions applied to its "Subfolders & Items within Folder" are not working as expected after importing 11g JAR file.

Steps for verifying the issue:

Create a new Folder: TEST

1. Create a new folder under 'Shared Folders'. For e.g., 'Test'.
2. Create a new application Role. For e.g., 'BI Admin'.
3. Navigate to Catalog --> Shared Folder --> Test Folder --> Permissions Tab, assign 'BI Admin' and choose 'Custom' permissions.
4. Select the following custom permissions for 'BI Admin' --> "Read, Write, Delete". Refer the attached screenshot.
5. Select the following: 
   1. Apply Permissions to sub-folders
   2. Apply permissions to items within the folder.

Create 2 sub-folders inside the  'TEST' folder

1. Create 2 sub-folders. For e.g, TEST_1 & TEST_2.
2. Assign 'BI Admin' application role to the above sub-folders.
3. Change the permissions from 'Custom' to 'Full Control'.

Create a new User: Testuser

1. 1. Create a new user. For e.g, Testuser.
   2. Assign the user as a member of application role - 'BI Admin'.

Observations with different users: [weblogic & Testuser]

1. 1. Weblogic User: Go to Catalog --> Shared Folder --> Test Folder: can see two sub-folders [TEST_1 & TEST_2].
   2. Testuser: Go to Catalog --> Shared Folder --> Test Folder: The folder is empty and this user is not able to see any sub-folders.

Analysis:

• • In 11g, a user having Application Role -  "BI Admin" with Custom Permissions (Read, Write, Delete) can navigate to 'sub-Folders' and can access the items present inside the sub-folders.
  • In 12c,  After importing 11g JAR file, Same Permissions are not being applied. So the users can see 'Empty'.

Changes

The JAR file is migrated from 11.1.1.7.170418 to 12.2.1.3.0.

Cause

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