tables for OBIEE object level permission check — Oracle Analytics

Oracle Analytics Cloud and Server

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

tables for OBIEE object level permission check

Received Response
42
Views
4
Comments
kp2000
kp2000 Rank 3 - Community Apprentice

Hello

Are there Oracle DB tables related to OBIEE to check

1-user permissions on a OBIEE Report

or

2-User Permissions on a view ( views which we found from physical sql related to OBIEE Subject Area)

Appreciate your help


thanks

kp

Answers

  • Hi,

    You aren't very precise, so the answers will be as generic.

    1) In OBIEE the catalog permissions are stored into the catalog itself, not in any database (things are different with the latest version but it isn't called OBIEE, therefore it isn't the topic of your question).

    2) No idea what you are talking about: a view found from physical SQL related to a subject area? I really don't see what you mean here...

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

    @Gianni Ceresa probably a random usage of words instead of precise denominations.

    @kp2000 are you talking about dashboards or pages or other visual objects? Because already the "report" is with 99% certainty not a "report" but rather an "analysis".

    Words are important since analytics means technology and precision is everything.

  • kp2000
    kp2000 Rank 3 - Community Apprentice

    Hello Gianni and Christian Berg,

    Thanks So Much for taking time to help me. I am sorry that I might not be specific in my questions. I wanted to know if there is a way in DB tables to see the Access permissions of a User on a Subject Area. But now i understand that it wont be stored at DB level.



    thanks

    kp

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

    "DB tables to see the Access permissions of a User on a Subject Area." I suspect your question is in relation to this: https://community.oracle.com/tech/apps-infra/discussion/4480001/user-not-able-to-access-a-report-fellow-team-member-can#latest

    Check my screenshot there.