Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC Custom Application Role Issue

Received Response
13
Views
1
Comments

Hii OAC Team, We have a requirement to grant user role permission equivalent to BI Consumer + Create and Edit Existing Workbooks +Ability to import existing datasets after creating workbook .We created a custom Application role and added the user under users section of this custom role and defined Permissions, Application Roles etc. as shown in below images .After this, the user after login gets the message displayed :Insufficient Permissions: You do not have sufficient permissions to use this application. Pls advise whether we are missing something ?: Thank you,

image.png image.png image.png image.png image.png

Answers

  • Gianni Ceresa
    edited Oct 24, 2025 10:35AM

    If you want your application role to be BI Consumer plus other permissions, the easiest in my opinion would be to have your new application role to inherit from BI Consumer. Therefore you should see BI Consumer in the "Memberships" screen. It would be easier to manage because in permissions you would only need to add the extra permissions you want on top of BI Consumer and not have to replicate all the BI Consumer permissions in the first place.

    And why do you make all those other default application roles as members? If you have a very custom security model, you better build it independently and make your own custom roles inherit from the default one when needed, but not the other way round.

    Also, BI Consumer vs DV Consumer: if you works in DV and not "classic", you maybe wanted to start from DV Consumer instead of BI Consumer?

    Just as reference, from the documentation, keep in mind the default inheritances in place for the default roles:

    image.png