Oracle Fusion Data Intelligence

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

How to give access to user to specific OTBI report

Received Response
223
Views
5
Comments
Francis Thériault
Francis Thériault Rank 1 - Community Starter

Summary

How to give access to user to specific OTBI report

Content

Hi All

Do you know of a way to give access to a custom report to a specific user?

I've try to add the user to the permission but user still get error message

Version

20D

Answers

  • Prudence K
    Prudence K Rank 5 - Community Champion

    Francis - this error seems like a report (or data configuration) issue and not a security issue?  Does the report run/work for you or others?

  • Francis Thériault
    Francis Thériault Rank 1 - Community Starter

    Hi Prudence,

    Yes indeed the report in question is working for me and for my supervisor but i think its related to a specific role, the goal for this is to only give the acces to this report to a specific user without giving access to all report.

    thanks

  • Pritesh Maurya
    Pritesh Maurya Rank 1 - Community Starter

    Hi, 

    Did you get any solution for this error issue, we are facing same problem with one of OTBI report, where user who created report is able to run it, while any other user who have access for report still not able to run it and getting same error msg. 

     

    Pls let me know if there is any solution. 

     

    Thanks,

    Pritesh  

  • SantoshKumarBhairi
    SantoshKumarBhairi Rank 6 - Analytics Lead

    hi Pritesh,

    What's the error message? Inaccessible column?  If so, you would need to grant the relevant bi-transaction duty roles.

    thanks,

    Santosh

  • Pritesh Maurya
    Pritesh Maurya Rank 1 - Community Starter

    Hi Santosh, 

    Yes, the issue was with the Duty roles missing to other users and they were not having relevant Subject area access bcs of same error was coming, after assigning applicable Duty roles for OTBI subject area other user able to run the report successfully. 

    Thanks for replying. Hope this helps to others. 

    Thanks,

    Pritesh