Users not able to access Direct Database tables on OBIEE dashboard. — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Users not able to access Direct Database tables on OBIEE dashboard.

Received Response
61
Views
10
Comments
DollyG
DollyG Rank 5 - Community Champion
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

Hi,

I have created a dashboard with 6 tables where 4 tables are created using Criteria tab, and another 2 tables are created using direct database request.

Some particular users are not able to view the tables on dashboard that are created using Direct Database request. I think that's an access issue.

Can someone please let me know, how to provide access in this case, or a suitable way in which the tables becomes visible to all the users?

Thanks and regards,

Dolly

Answers

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

    Hi,

    If I'm not mistaken, there's a privilege in the administration section which is something like "Execute Direct Database Analysis". You'll probably need to grant that privilege to users/roles who should see those analysis.

  • DollyG
    DollyG Rank 5 - Community Champion

    Thanks Pedro

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    You have to set that in RPD also....Do that in Identity manager. for the connection to be used as direct database connection you need to allow that user role to run direct db connection.

    pastedImage_0.png

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    You will run into a management nightmare with the general user population having the ability to generate Direct Requests .. I'd rethink displaying these requests on a generally available dashboard.

  • DollyG
    DollyG Rank 5 - Community Champion

    Thanks Arijit and Thomas,

    I just want the users to execute Direct Database request. I do not want to allow them to generate Direct Database request. For my requirement, what changes I need to make in the rpd?

  • 3068122
    3068122 Rank 4 - Community Specialist

    Hi DollyG ,

    maybe you should give "Execute Direct Database Analysis" privilege to users/roles.

    pastedImage_0.png

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Btw - others might disagree - but for me direct database request is not a permanent solution, but a temporary tool useful for DBA or developers to get a quick answer.

    I would model your ddr's into opaque views at the very minimum.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Amen to that.

  • DollyG
    DollyG Rank 5 - Community Champion

    So, u mean to say, I should not create analysis using DDR?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    I mean you should not create permanent solutions using DDR, they bypass all of the advantages of using OBIEE, if you just want DDR as a solution then you may as well go back to discoverer custom folders... (were it supported)