Is there a way to get mapping between column and Permissions(security role) in OBIEE — 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

Is there a way to get mapping between column and Permissions(security role) in OBIEE

Received Response
1
Views
5
Comments
3289203
3289203 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:09PM in Oracle Analytics Cloud and Server

I am trying to find User/Group permissions a particular column has in OBIEE. Was able to extract

tools-> utilities -> repository

documentation & get list of column in presentation layer.

But this doesn't provide Application roles applied to the table/column.

Is there a way I can get mapping this?

Answers

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

    You can get.that from the detailex XUDML files.

    Sry just boarding a plane...

  • 3289203
    3289203 Rank 3 - Community Apprentice

    Thanks for the help.. but iam not sure how to open the xsd file & find the relation. Any pointer would be helpful

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

    XSD?!

  • 3289203
    3289203 Rank 3 - Community Apprentice

    found ORACLE_HOME/bifoundation/server/bin/xudml_mds_core.xsd file i thought this is the file you were suggesting

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

    I meant transforming your RPD into MDS XML files or copy/pasting the udml from the RPD into Notepad++ (shameless plug)