tables for OBIEE object level permission check

kp2000 · Jan 22, 2021 11:13PM

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

Gianni Ceresa · Jan 23, 2021 10:29AM

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] · Jan 24, 2021 1:17PM

@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 · Jan 25, 2021 5:29PM

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] · Jan 26, 2021 8:25AM

"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.

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

tables for OBIEE object level permission check

Answers