Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

QUERY Group|Security Role|Application Role in OBIEE 12G

Received Response
22
Views
2
Comments
rahul.r.singh
rahul.r.singh Rank 1 - Community Starter
edited Aug 13, 2024 6:13PM in Oracle Analytics Forum

Hi All,

We have below user assigned to different role. can I know in which table the data is storing these user value. as I want to prepare the query and want to see in DB with user of different role.

OBIEE_Group.JPG

Thanks,

SK

Answers

  • rahul.r.singh
    rahul.r.singh Rank 1 - Community Starter

    Anyone update on this issue.

    Thanks,

    SK

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

    You're not supposed query the repository table for this. The tables are in the schema of OPSS and there's a lovely 157 or them called CT_1 through CT_157. Should be quite clear that this alone plus the fact that there's no documentation means: "No. Do NOT query."

    You're supposed to use EM and/or WLST.